using System;
using System.Data.Common;
using PKTools.Database;
namespace PKTools.SqlObjects
{
	public partial class SfParameter : SqlStampedObject
	{
		public const string SelectQuery = "[ID],[InputName],[Type],[Value],[TestValue],[MapInput],[SystemParameterID],[Override],[Enabled],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_PARAMETER]";
		Int32 __f0;
		public Int32 ID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		String __f1;
		public String InputName
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int16 __f2;
		public Int16 Type
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		String __f3;
		public String Value
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		String __f4;
		public String TestValue
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		String __f5;
		public String MapInput
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		Int32? __f6;
		public Int32? SystemParameterID
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Boolean __f7;
		public Boolean Override
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		Boolean __f8;
		public Boolean Enabled
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		Int32? __f9;
		public Int32? ReferenceID
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		DateTime? __f10;
		public DateTime? LastUpdateOn
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String LastUpdatedBy
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		DateTime? __f12;
		public DateTime? CreatedOn
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		String __f13;
		public String CreatedBy
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		Boolean __f14;
		public Boolean Active
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		DateTime? __f15;
		public DateTime? LastDeleteOn
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		String __f16;
		public String LastDeletedBy
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		DateTime? __f17;
		public DateTime? LastReactivateOn
		{
			get { return this.__f17; }
			set
			{
				if (this.__f17 == value) return;
				this.__f17 = value; this.__changed[17] = true;
			}
		}
		String __f18;
		public String LastReactivatedBy
		{
			get { return this.__f18; }
			set
			{
				if (this.__f18 == value) return;
				this.__f18 = value; this.__changed[18] = true;
			}
		}
		Int32? __f19;
		public Int32? ArchiveID
		{
			get { return this.__f19; }
			set
			{
				if (this.__f19 == value) return;
				this.__f19 = value; this.__changed[19] = true;
			}
		}
		DateTime? __f20;
		public DateTime? LastArchiveOn
		{
			get { return this.__f20; }
			set
			{
				if (this.__f20 == value) return;
				this.__f20 = value; this.__changed[20] = true;
			}
		}
		String __f21;
		public String LastArchivedBy
		{
			get { return this.__f21; }
			set
			{
				if (this.__f21 == value) return;
				this.__f21 = value; this.__changed[21] = true;
			}
		}
		DateTime? __f22;
		public DateTime? LastRestoreOn
		{
			get { return this.__f22; }
			set
			{
				if (this.__f22 == value) return;
				this.__f22 = value; this.__changed[22] = true;
			}
		}
		String __f23;
		public String LastRestoredBy
		{
			get { return this.__f23; }
			set
			{
				if (this.__f23 == value) return;
				this.__f23 = value; this.__changed[23] = true;
			}
		}
		public SfParameter()
		{
			this.__table = "SF_PARAMETER";
			this.__fields = new [] { "ID","InputName","Type","Value","TestValue","MapInput","SystemParameterID","Override","Enabled","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16,()=>this.__f17,()=>this.__f18,()=>this.__f19,()=>this.__f20,()=>this.__f21,()=>this.__f22,()=>this.__f23 };
			this.__changed = new bool[24];
			this.__isPK = new [] { true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = 0;
		}
		protected override void SetIdentity(int value)
		{
			this.__f0 = value;
		}
		public static SfParameter LoadByPK(Sql sql, Int32 ID)
		{
			sql.Clear();
			sql.AddInput("ID", ID);
			return LoadRecord<SfParameter>(sql, $"SELECT {SelectQuery} WHERE [ID]=@ID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ID"];
			this.__f1 = (String)reader["InputName"];
			this.__f2 = (Int16)reader["Type"];
			this.__f3 = EmptyToNull(reader["Value"]);
			this.__f4 = EmptyToNull(reader["TestValue"]);
			this.__f5 = EmptyToNull(reader["MapInput"]);
			this.__f6 = ToNullable<Int32>(reader["SystemParameterID"]);
			this.__f7 = (Boolean)reader["Override"];
			this.__f8 = (Boolean)reader["Enabled"];
			this.__f9 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f10 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f11 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f12 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f13 = EmptyToNull(reader["CreatedBy"]);
			this.__f14 = (Boolean)reader["Active"];
			this.__f15 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f16 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f17 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f18 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f19 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f20 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f21 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f22 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f23 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfViewActionRole : SqlStampedObject
	{
		public const string SelectQuery = "[ViewActionID],[RoleID],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_VIEW_ACTION_ROLE]";
		Int32 __f0;
		public Int32 ViewActionID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32 __f1;
		public Int32 RoleID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32? __f2;
		public Int32? ReferenceID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		DateTime? __f3;
		public DateTime? LastUpdateOn
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		String __f4;
		public String LastUpdatedBy
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		DateTime? __f5;
		public DateTime? CreatedOn
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		String __f6;
		public String CreatedBy
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Boolean __f7;
		public Boolean Active
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		DateTime? __f8;
		public DateTime? LastDeleteOn
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String LastDeletedBy
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		DateTime? __f10;
		public DateTime? LastReactivateOn
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String LastReactivatedBy
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Int32? __f12;
		public Int32? ArchiveID
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		DateTime? __f13;
		public DateTime? LastArchiveOn
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		String __f14;
		public String LastArchivedBy
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		DateTime? __f15;
		public DateTime? LastRestoreOn
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		String __f16;
		public String LastRestoredBy
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		public SfViewActionRole()
		{
			this.__table = "SF_VIEW_ACTION_ROLE";
			this.__fields = new [] { "ViewActionID","RoleID","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16 };
			this.__changed = new bool[17];
			this.__isPK = new [] { true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = -1;
		}
		public static SfViewActionRole LoadByPK(Sql sql, Int32 ViewActionID,Int32 RoleID)
		{
			sql.Clear();
			sql.AddInput("ViewActionID", ViewActionID);
			sql.AddInput("RoleID", RoleID);
			return LoadRecord<SfViewActionRole>(sql, $"SELECT {SelectQuery} WHERE [ViewActionID]=@ViewActionID AND [RoleID]=@RoleID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ViewActionID"];
			this.__f1 = (Int32)reader["RoleID"];
			this.__f2 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f3 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f4 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f5 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f6 = EmptyToNull(reader["CreatedBy"]);
			this.__f7 = (Boolean)reader["Active"];
			this.__f8 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f9 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f10 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f11 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f12 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f13 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f14 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f15 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f16 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfViewCategory : SqlStampedObject
	{
		public const string SelectQuery = "[ViewRevisionID],[CategoryID],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_VIEW_CATEGORY]";
		Int32 __f0;
		public Int32 ViewRevisionID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32 __f1;
		public Int32 CategoryID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32? __f2;
		public Int32? ReferenceID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		DateTime? __f3;
		public DateTime? LastUpdateOn
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		String __f4;
		public String LastUpdatedBy
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		DateTime? __f5;
		public DateTime? CreatedOn
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		String __f6;
		public String CreatedBy
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Boolean __f7;
		public Boolean Active
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		DateTime? __f8;
		public DateTime? LastDeleteOn
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String LastDeletedBy
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		DateTime? __f10;
		public DateTime? LastReactivateOn
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String LastReactivatedBy
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Int32? __f12;
		public Int32? ArchiveID
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		DateTime? __f13;
		public DateTime? LastArchiveOn
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		String __f14;
		public String LastArchivedBy
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		DateTime? __f15;
		public DateTime? LastRestoreOn
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		String __f16;
		public String LastRestoredBy
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		public SfViewCategory()
		{
			this.__table = "SF_VIEW_CATEGORY";
			this.__fields = new [] { "ViewRevisionID","CategoryID","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16 };
			this.__changed = new bool[17];
			this.__isPK = new [] { true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = -1;
		}
		public static SfViewCategory LoadByPK(Sql sql, Int32 ViewRevisionID,Int32 CategoryID)
		{
			sql.Clear();
			sql.AddInput("ViewRevisionID", ViewRevisionID);
			sql.AddInput("CategoryID", CategoryID);
			return LoadRecord<SfViewCategory>(sql, $"SELECT {SelectQuery} WHERE [ViewRevisionID]=@ViewRevisionID AND [CategoryID]=@CategoryID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ViewRevisionID"];
			this.__f1 = (Int32)reader["CategoryID"];
			this.__f2 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f3 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f4 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f5 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f6 = EmptyToNull(reader["CreatedBy"]);
			this.__f7 = (Boolean)reader["Active"];
			this.__f8 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f9 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f10 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f11 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f12 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f13 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f14 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f15 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f16 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfViewForm : SqlStampedObject
	{
		public const string SelectQuery = "[ID],[ViewRevisionID],[Name],[FUID],[PositionOrder],[TitleTextID],[ShowTitle],[ColumnCount],[Style],[CssClass],[Focus],[State],[Enabled],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_VIEW_FORM]";
		Int32 __f0;
		public Int32 ID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32 __f1;
		public Int32 ViewRevisionID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		String __f2;
		public String Name
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		String __f3;
		public String FUID
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		Int32 __f4;
		public Int32 PositionOrder
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		Int32? __f5;
		public Int32? TitleTextID
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		Boolean __f6;
		public Boolean ShowTitle
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Int32 __f7;
		public Int32 ColumnCount
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		String __f8;
		public String Style
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String CssClass
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		String __f10;
		public String Focus
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		Int16 __f11;
		public Int16 State
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Boolean __f12;
		public Boolean Enabled
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		Int32? __f13;
		public Int32? ReferenceID
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		DateTime? __f14;
		public DateTime? LastUpdateOn
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		String __f15;
		public String LastUpdatedBy
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		DateTime? __f16;
		public DateTime? CreatedOn
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		String __f17;
		public String CreatedBy
		{
			get { return this.__f17; }
			set
			{
				if (this.__f17 == value) return;
				this.__f17 = value; this.__changed[17] = true;
			}
		}
		Boolean __f18;
		public Boolean Active
		{
			get { return this.__f18; }
			set
			{
				if (this.__f18 == value) return;
				this.__f18 = value; this.__changed[18] = true;
			}
		}
		DateTime? __f19;
		public DateTime? LastDeleteOn
		{
			get { return this.__f19; }
			set
			{
				if (this.__f19 == value) return;
				this.__f19 = value; this.__changed[19] = true;
			}
		}
		String __f20;
		public String LastDeletedBy
		{
			get { return this.__f20; }
			set
			{
				if (this.__f20 == value) return;
				this.__f20 = value; this.__changed[20] = true;
			}
		}
		DateTime? __f21;
		public DateTime? LastReactivateOn
		{
			get { return this.__f21; }
			set
			{
				if (this.__f21 == value) return;
				this.__f21 = value; this.__changed[21] = true;
			}
		}
		String __f22;
		public String LastReactivatedBy
		{
			get { return this.__f22; }
			set
			{
				if (this.__f22 == value) return;
				this.__f22 = value; this.__changed[22] = true;
			}
		}
		Int32? __f23;
		public Int32? ArchiveID
		{
			get { return this.__f23; }
			set
			{
				if (this.__f23 == value) return;
				this.__f23 = value; this.__changed[23] = true;
			}
		}
		DateTime? __f24;
		public DateTime? LastArchiveOn
		{
			get { return this.__f24; }
			set
			{
				if (this.__f24 == value) return;
				this.__f24 = value; this.__changed[24] = true;
			}
		}
		String __f25;
		public String LastArchivedBy
		{
			get { return this.__f25; }
			set
			{
				if (this.__f25 == value) return;
				this.__f25 = value; this.__changed[25] = true;
			}
		}
		DateTime? __f26;
		public DateTime? LastRestoreOn
		{
			get { return this.__f26; }
			set
			{
				if (this.__f26 == value) return;
				this.__f26 = value; this.__changed[26] = true;
			}
		}
		String __f27;
		public String LastRestoredBy
		{
			get { return this.__f27; }
			set
			{
				if (this.__f27 == value) return;
				this.__f27 = value; this.__changed[27] = true;
			}
		}
		public SfViewForm()
		{
			this.__table = "SF_VIEW_FORM";
			this.__fields = new [] { "ID","ViewRevisionID","Name","FUID","PositionOrder","TitleTextID","ShowTitle","ColumnCount","Style","CssClass","Focus","State","Enabled","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16,()=>this.__f17,()=>this.__f18,()=>this.__f19,()=>this.__f20,()=>this.__f21,()=>this.__f22,()=>this.__f23,()=>this.__f24,()=>this.__f25,()=>this.__f26,()=>this.__f27 };
			this.__changed = new bool[28];
			this.__isPK = new [] { true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = 0;
		}
		protected override void SetIdentity(int value)
		{
			this.__f0 = value;
		}
		public static SfViewForm LoadByPK(Sql sql, Int32 ID)
		{
			sql.Clear();
			sql.AddInput("ID", ID);
			return LoadRecord<SfViewForm>(sql, $"SELECT {SelectQuery} WHERE [ID]=@ID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ID"];
			this.__f1 = (Int32)reader["ViewRevisionID"];
			this.__f2 = (String)reader["Name"];
			this.__f3 = (String)reader["FUID"];
			this.__f4 = (Int32)reader["PositionOrder"];
			this.__f5 = ToNullable<Int32>(reader["TitleTextID"]);
			this.__f6 = (Boolean)reader["ShowTitle"];
			this.__f7 = (Int32)reader["ColumnCount"];
			this.__f8 = EmptyToNull(reader["Style"]);
			this.__f9 = EmptyToNull(reader["CssClass"]);
			this.__f10 = EmptyToNull(reader["Focus"]);
			this.__f11 = (Int16)reader["State"];
			this.__f12 = (Boolean)reader["Enabled"];
			this.__f13 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f14 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f15 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f16 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f17 = EmptyToNull(reader["CreatedBy"]);
			this.__f18 = (Boolean)reader["Active"];
			this.__f19 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f20 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f21 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f22 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f23 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f24 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f25 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f26 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f27 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfScreenParameter : SqlStampedObject
	{
		public const string SelectQuery = "[ScreenRevisionID],[ParameterID],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_SCREEN_PARAMETER]";
		Int32 __f0;
		public Int32 ScreenRevisionID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32 __f1;
		public Int32 ParameterID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32? __f2;
		public Int32? ReferenceID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		DateTime? __f3;
		public DateTime? LastUpdateOn
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		String __f4;
		public String LastUpdatedBy
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		DateTime? __f5;
		public DateTime? CreatedOn
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		String __f6;
		public String CreatedBy
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Boolean __f7;
		public Boolean Active
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		DateTime? __f8;
		public DateTime? LastDeleteOn
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String LastDeletedBy
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		DateTime? __f10;
		public DateTime? LastReactivateOn
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String LastReactivatedBy
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Int32? __f12;
		public Int32? ArchiveID
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		DateTime? __f13;
		public DateTime? LastArchiveOn
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		String __f14;
		public String LastArchivedBy
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		DateTime? __f15;
		public DateTime? LastRestoreOn
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		String __f16;
		public String LastRestoredBy
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		public SfScreenParameter()
		{
			this.__table = "SF_SCREEN_PARAMETER";
			this.__fields = new [] { "ScreenRevisionID","ParameterID","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16 };
			this.__changed = new bool[17];
			this.__isPK = new [] { true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = -1;
		}
		public static SfScreenParameter LoadByPK(Sql sql, Int32 ScreenRevisionID,Int32 ParameterID)
		{
			sql.Clear();
			sql.AddInput("ScreenRevisionID", ScreenRevisionID);
			sql.AddInput("ParameterID", ParameterID);
			return LoadRecord<SfScreenParameter>(sql, $"SELECT {SelectQuery} WHERE [ScreenRevisionID]=@ScreenRevisionID AND [ParameterID]=@ParameterID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ScreenRevisionID"];
			this.__f1 = (Int32)reader["ParameterID"];
			this.__f2 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f3 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f4 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f5 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f6 = EmptyToNull(reader["CreatedBy"]);
			this.__f7 = (Boolean)reader["Active"];
			this.__f8 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f9 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f10 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f11 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f12 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f13 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f14 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f15 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f16 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfScreen : SqlStampedObject
	{
		public const string SelectQuery = "[ID],[FUID],[Name],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_SCREEN]";
		Int32 __f0;
		public Int32 ID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		String __f1;
		public String FUID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		String __f2;
		public String Name
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		Int32? __f3;
		public Int32? ReferenceID
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		DateTime? __f4;
		public DateTime? LastUpdateOn
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		String __f5;
		public String LastUpdatedBy
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		DateTime? __f6;
		public DateTime? CreatedOn
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		String __f7;
		public String CreatedBy
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		Boolean __f8;
		public Boolean Active
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		DateTime? __f9;
		public DateTime? LastDeleteOn
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		String __f10;
		public String LastDeletedBy
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		DateTime? __f11;
		public DateTime? LastReactivateOn
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		String __f12;
		public String LastReactivatedBy
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		Int32? __f13;
		public Int32? ArchiveID
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		DateTime? __f14;
		public DateTime? LastArchiveOn
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		String __f15;
		public String LastArchivedBy
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		DateTime? __f16;
		public DateTime? LastRestoreOn
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		String __f17;
		public String LastRestoredBy
		{
			get { return this.__f17; }
			set
			{
				if (this.__f17 == value) return;
				this.__f17 = value; this.__changed[17] = true;
			}
		}
		public SfScreen()
		{
			this.__table = "SF_SCREEN";
			this.__fields = new [] { "ID","FUID","Name","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16,()=>this.__f17 };
			this.__changed = new bool[18];
			this.__isPK = new [] { true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = 0;
		}
		protected override void SetIdentity(int value)
		{
			this.__f0 = value;
		}
		public static SfScreen LoadByPK(Sql sql, Int32 ID)
		{
			sql.Clear();
			sql.AddInput("ID", ID);
			return LoadRecord<SfScreen>(sql, $"SELECT {SelectQuery} WHERE [ID]=@ID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ID"];
			this.__f1 = (String)reader["FUID"];
			this.__f2 = (String)reader["Name"];
			this.__f3 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f4 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f5 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f6 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f7 = EmptyToNull(reader["CreatedBy"]);
			this.__f8 = (Boolean)reader["Active"];
			this.__f9 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f10 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f11 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f12 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f13 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f14 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f15 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f16 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f17 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfViewFormControl : SqlStampedObject
	{
		public const string SelectQuery = "[ID],[ViewFormID],[Code],[FUID],[DataType],[Type],[TitleTextId],[ShowTitle],[DisplayFormat],[InitialValue],[DefaultValue],[SubmitAction],[SpanOver],[DictionaryCode],[MaxTextLength],[OnChangeOperationCode],[OnChangeOperationID],[Style],[CssClass],[IsRequired],[Properties],[DisplayOption],[PositionOrder],[SystemParameterID],[Enabled],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_VIEW_FORM_CONTROL]";
		Int32 __f0;
		public Int32 ID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32 __f1;
		public Int32 ViewFormID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		String __f2;
		public String Code
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		String __f3;
		public String FUID
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		Int16 __f4;
		public Int16 DataType
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		Int16 __f5;
		public Int16 Type
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		Int32? __f6;
		public Int32? TitleTextId
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Boolean __f7;
		public Boolean ShowTitle
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		String __f8;
		public String DisplayFormat
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String InitialValue
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		String __f10;
		public String DefaultValue
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String SubmitAction
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Int32 __f12;
		public Int32 SpanOver
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		String __f13;
		public String DictionaryCode
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		Int32 __f14;
		public Int32 MaxTextLength
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		String __f15;
		public String OnChangeOperationCode
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		Int32? __f16;
		public Int32? OnChangeOperationID
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		String __f17;
		public String Style
		{
			get { return this.__f17; }
			set
			{
				if (this.__f17 == value) return;
				this.__f17 = value; this.__changed[17] = true;
			}
		}
		String __f18;
		public String CssClass
		{
			get { return this.__f18; }
			set
			{
				if (this.__f18 == value) return;
				this.__f18 = value; this.__changed[18] = true;
			}
		}
		Boolean __f19;
		public Boolean IsRequired
		{
			get { return this.__f19; }
			set
			{
				if (this.__f19 == value) return;
				this.__f19 = value; this.__changed[19] = true;
			}
		}
		String __f20;
		public String Properties
		{
			get { return this.__f20; }
			set
			{
				if (this.__f20 == value) return;
				this.__f20 = value; this.__changed[20] = true;
			}
		}
		Int16 __f21;
		public Int16 DisplayOption
		{
			get { return this.__f21; }
			set
			{
				if (this.__f21 == value) return;
				this.__f21 = value; this.__changed[21] = true;
			}
		}
		Int32 __f22;
		public Int32 PositionOrder
		{
			get { return this.__f22; }
			set
			{
				if (this.__f22 == value) return;
				this.__f22 = value; this.__changed[22] = true;
			}
		}
		Int32? __f23;
		public Int32? SystemParameterID
		{
			get { return this.__f23; }
			set
			{
				if (this.__f23 == value) return;
				this.__f23 = value; this.__changed[23] = true;
			}
		}
		Boolean __f24;
		public Boolean Enabled
		{
			get { return this.__f24; }
			set
			{
				if (this.__f24 == value) return;
				this.__f24 = value; this.__changed[24] = true;
			}
		}
		Int32? __f25;
		public Int32? ReferenceID
		{
			get { return this.__f25; }
			set
			{
				if (this.__f25 == value) return;
				this.__f25 = value; this.__changed[25] = true;
			}
		}
		DateTime? __f26;
		public DateTime? LastUpdateOn
		{
			get { return this.__f26; }
			set
			{
				if (this.__f26 == value) return;
				this.__f26 = value; this.__changed[26] = true;
			}
		}
		String __f27;
		public String LastUpdatedBy
		{
			get { return this.__f27; }
			set
			{
				if (this.__f27 == value) return;
				this.__f27 = value; this.__changed[27] = true;
			}
		}
		DateTime? __f28;
		public DateTime? CreatedOn
		{
			get { return this.__f28; }
			set
			{
				if (this.__f28 == value) return;
				this.__f28 = value; this.__changed[28] = true;
			}
		}
		String __f29;
		public String CreatedBy
		{
			get { return this.__f29; }
			set
			{
				if (this.__f29 == value) return;
				this.__f29 = value; this.__changed[29] = true;
			}
		}
		Boolean __f30;
		public Boolean Active
		{
			get { return this.__f30; }
			set
			{
				if (this.__f30 == value) return;
				this.__f30 = value; this.__changed[30] = true;
			}
		}
		DateTime? __f31;
		public DateTime? LastDeleteOn
		{
			get { return this.__f31; }
			set
			{
				if (this.__f31 == value) return;
				this.__f31 = value; this.__changed[31] = true;
			}
		}
		String __f32;
		public String LastDeletedBy
		{
			get { return this.__f32; }
			set
			{
				if (this.__f32 == value) return;
				this.__f32 = value; this.__changed[32] = true;
			}
		}
		DateTime? __f33;
		public DateTime? LastReactivateOn
		{
			get { return this.__f33; }
			set
			{
				if (this.__f33 == value) return;
				this.__f33 = value; this.__changed[33] = true;
			}
		}
		String __f34;
		public String LastReactivatedBy
		{
			get { return this.__f34; }
			set
			{
				if (this.__f34 == value) return;
				this.__f34 = value; this.__changed[34] = true;
			}
		}
		Int32? __f35;
		public Int32? ArchiveID
		{
			get { return this.__f35; }
			set
			{
				if (this.__f35 == value) return;
				this.__f35 = value; this.__changed[35] = true;
			}
		}
		DateTime? __f36;
		public DateTime? LastArchiveOn
		{
			get { return this.__f36; }
			set
			{
				if (this.__f36 == value) return;
				this.__f36 = value; this.__changed[36] = true;
			}
		}
		String __f37;
		public String LastArchivedBy
		{
			get { return this.__f37; }
			set
			{
				if (this.__f37 == value) return;
				this.__f37 = value; this.__changed[37] = true;
			}
		}
		DateTime? __f38;
		public DateTime? LastRestoreOn
		{
			get { return this.__f38; }
			set
			{
				if (this.__f38 == value) return;
				this.__f38 = value; this.__changed[38] = true;
			}
		}
		String __f39;
		public String LastRestoredBy
		{
			get { return this.__f39; }
			set
			{
				if (this.__f39 == value) return;
				this.__f39 = value; this.__changed[39] = true;
			}
		}
		public SfViewFormControl()
		{
			this.__table = "SF_VIEW_FORM_CONTROL";
			this.__fields = new [] { "ID","ViewFormID","Code","FUID","DataType","Type","TitleTextId","ShowTitle","DisplayFormat","InitialValue","DefaultValue","SubmitAction","SpanOver","DictionaryCode","MaxTextLength","OnChangeOperationCode","OnChangeOperationID","Style","CssClass","IsRequired","Properties","DisplayOption","PositionOrder","SystemParameterID","Enabled","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16,()=>this.__f17,()=>this.__f18,()=>this.__f19,()=>this.__f20,()=>this.__f21,()=>this.__f22,()=>this.__f23,()=>this.__f24,()=>this.__f25,()=>this.__f26,()=>this.__f27,()=>this.__f28,()=>this.__f29,()=>this.__f30,()=>this.__f31,()=>this.__f32,()=>this.__f33,()=>this.__f34,()=>this.__f35,()=>this.__f36,()=>this.__f37,()=>this.__f38,()=>this.__f39 };
			this.__changed = new bool[40];
			this.__isPK = new [] { true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = 0;
		}
		protected override void SetIdentity(int value)
		{
			this.__f0 = value;
		}
		public static SfViewFormControl LoadByPK(Sql sql, Int32 ID)
		{
			sql.Clear();
			sql.AddInput("ID", ID);
			return LoadRecord<SfViewFormControl>(sql, $"SELECT {SelectQuery} WHERE [ID]=@ID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ID"];
			this.__f1 = (Int32)reader["ViewFormID"];
			this.__f2 = (String)reader["Code"];
			this.__f3 = (String)reader["FUID"];
			this.__f4 = (Int16)reader["DataType"];
			this.__f5 = (Int16)reader["Type"];
			this.__f6 = ToNullable<Int32>(reader["TitleTextId"]);
			this.__f7 = (Boolean)reader["ShowTitle"];
			this.__f8 = EmptyToNull(reader["DisplayFormat"]);
			this.__f9 = EmptyToNull(reader["InitialValue"]);
			this.__f10 = EmptyToNull(reader["DefaultValue"]);
			this.__f11 = EmptyToNull(reader["SubmitAction"]);
			this.__f12 = (Int32)reader["SpanOver"];
			this.__f13 = EmptyToNull(reader["DictionaryCode"]);
			this.__f14 = (Int32)reader["MaxTextLength"];
			this.__f15 = EmptyToNull(reader["OnChangeOperationCode"]);
			this.__f16 = ToNullable<Int32>(reader["OnChangeOperationID"]);
			this.__f17 = EmptyToNull(reader["Style"]);
			this.__f18 = EmptyToNull(reader["CssClass"]);
			this.__f19 = (Boolean)reader["IsRequired"];
			this.__f20 = EmptyToNull(reader["Properties"]);
			this.__f21 = (Int16)reader["DisplayOption"];
			this.__f22 = (Int32)reader["PositionOrder"];
			this.__f23 = ToNullable<Int32>(reader["SystemParameterID"]);
			this.__f24 = (Boolean)reader["Enabled"];
			this.__f25 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f26 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f27 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f28 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f29 = EmptyToNull(reader["CreatedBy"]);
			this.__f30 = (Boolean)reader["Active"];
			this.__f31 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f32 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f33 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f34 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f35 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f36 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f37 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f38 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f39 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfScreenRevision : SqlStampedObject
	{
		public const string SelectQuery = "[ID],[FUID],[ScreenID],[Revision],[RevisionStatusID],[IsDefaultRevision],[LayoutID],[TitleTextID],[Description],[Instance],[NavigationType],[Landing],[QuickAccess],[OnInitializeOperationCode],[OnInitializeOperationID],[OnLoadOperationCode],[OnLoadOperationID],[SoundEffectType],[Properties],[DocumentationID],[HeaderViewID],[HeaderViewRevisionID],[IsTemplate],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_SCREEN_REVISION]";
		Int32 __f0;
		public Int32 ID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		String __f1;
		public String FUID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32 __f2;
		public Int32 ScreenID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		String __f3;
		public String Revision
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		Int16 __f4;
		public Int16 RevisionStatusID
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		Boolean __f5;
		public Boolean IsDefaultRevision
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		Int32? __f6;
		public Int32? LayoutID
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Int32? __f7;
		public Int32? TitleTextID
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		String __f8;
		public String Description
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String Instance
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		Int16 __f10;
		public Int16 NavigationType
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		Boolean? __f11;
		public Boolean? Landing
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Boolean __f12;
		public Boolean QuickAccess
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		String __f13;
		public String OnInitializeOperationCode
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		Int32? __f14;
		public Int32? OnInitializeOperationID
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		String __f15;
		public String OnLoadOperationCode
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		Int32? __f16;
		public Int32? OnLoadOperationID
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		Int16 __f17;
		public Int16 SoundEffectType
		{
			get { return this.__f17; }
			set
			{
				if (this.__f17 == value) return;
				this.__f17 = value; this.__changed[17] = true;
			}
		}
		String __f18;
		public String Properties
		{
			get { return this.__f18; }
			set
			{
				if (this.__f18 == value) return;
				this.__f18 = value; this.__changed[18] = true;
			}
		}
		Int32? __f19;
		public Int32? DocumentationID
		{
			get { return this.__f19; }
			set
			{
				if (this.__f19 == value) return;
				this.__f19 = value; this.__changed[19] = true;
			}
		}
		Int32? __f20;
		public Int32? HeaderViewID
		{
			get { return this.__f20; }
			set
			{
				if (this.__f20 == value) return;
				this.__f20 = value; this.__changed[20] = true;
			}
		}
		Int32? __f21;
		public Int32? HeaderViewRevisionID
		{
			get { return this.__f21; }
			set
			{
				if (this.__f21 == value) return;
				this.__f21 = value; this.__changed[21] = true;
			}
		}
		Boolean __f22;
		public Boolean IsTemplate
		{
			get { return this.__f22; }
			set
			{
				if (this.__f22 == value) return;
				this.__f22 = value; this.__changed[22] = true;
			}
		}
		Int32? __f23;
		public Int32? ReferenceID
		{
			get { return this.__f23; }
			set
			{
				if (this.__f23 == value) return;
				this.__f23 = value; this.__changed[23] = true;
			}
		}
		DateTime? __f24;
		public DateTime? LastUpdateOn
		{
			get { return this.__f24; }
			set
			{
				if (this.__f24 == value) return;
				this.__f24 = value; this.__changed[24] = true;
			}
		}
		String __f25;
		public String LastUpdatedBy
		{
			get { return this.__f25; }
			set
			{
				if (this.__f25 == value) return;
				this.__f25 = value; this.__changed[25] = true;
			}
		}
		DateTime? __f26;
		public DateTime? CreatedOn
		{
			get { return this.__f26; }
			set
			{
				if (this.__f26 == value) return;
				this.__f26 = value; this.__changed[26] = true;
			}
		}
		String __f27;
		public String CreatedBy
		{
			get { return this.__f27; }
			set
			{
				if (this.__f27 == value) return;
				this.__f27 = value; this.__changed[27] = true;
			}
		}
		Boolean __f28;
		public Boolean Active
		{
			get { return this.__f28; }
			set
			{
				if (this.__f28 == value) return;
				this.__f28 = value; this.__changed[28] = true;
			}
		}
		DateTime? __f29;
		public DateTime? LastDeleteOn
		{
			get { return this.__f29; }
			set
			{
				if (this.__f29 == value) return;
				this.__f29 = value; this.__changed[29] = true;
			}
		}
		String __f30;
		public String LastDeletedBy
		{
			get { return this.__f30; }
			set
			{
				if (this.__f30 == value) return;
				this.__f30 = value; this.__changed[30] = true;
			}
		}
		DateTime? __f31;
		public DateTime? LastReactivateOn
		{
			get { return this.__f31; }
			set
			{
				if (this.__f31 == value) return;
				this.__f31 = value; this.__changed[31] = true;
			}
		}
		String __f32;
		public String LastReactivatedBy
		{
			get { return this.__f32; }
			set
			{
				if (this.__f32 == value) return;
				this.__f32 = value; this.__changed[32] = true;
			}
		}
		Int32? __f33;
		public Int32? ArchiveID
		{
			get { return this.__f33; }
			set
			{
				if (this.__f33 == value) return;
				this.__f33 = value; this.__changed[33] = true;
			}
		}
		DateTime? __f34;
		public DateTime? LastArchiveOn
		{
			get { return this.__f34; }
			set
			{
				if (this.__f34 == value) return;
				this.__f34 = value; this.__changed[34] = true;
			}
		}
		String __f35;
		public String LastArchivedBy
		{
			get { return this.__f35; }
			set
			{
				if (this.__f35 == value) return;
				this.__f35 = value; this.__changed[35] = true;
			}
		}
		DateTime? __f36;
		public DateTime? LastRestoreOn
		{
			get { return this.__f36; }
			set
			{
				if (this.__f36 == value) return;
				this.__f36 = value; this.__changed[36] = true;
			}
		}
		String __f37;
		public String LastRestoredBy
		{
			get { return this.__f37; }
			set
			{
				if (this.__f37 == value) return;
				this.__f37 = value; this.__changed[37] = true;
			}
		}
		public SfScreenRevision()
		{
			this.__table = "SF_SCREEN_REVISION";
			this.__fields = new [] { "ID","FUID","ScreenID","Revision","RevisionStatusID","IsDefaultRevision","LayoutID","TitleTextID","Description","Instance","NavigationType","Landing","QuickAccess","OnInitializeOperationCode","OnInitializeOperationID","OnLoadOperationCode","OnLoadOperationID","SoundEffectType","Properties","DocumentationID","HeaderViewID","HeaderViewRevisionID","IsTemplate","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16,()=>this.__f17,()=>this.__f18,()=>this.__f19,()=>this.__f20,()=>this.__f21,()=>this.__f22,()=>this.__f23,()=>this.__f24,()=>this.__f25,()=>this.__f26,()=>this.__f27,()=>this.__f28,()=>this.__f29,()=>this.__f30,()=>this.__f31,()=>this.__f32,()=>this.__f33,()=>this.__f34,()=>this.__f35,()=>this.__f36,()=>this.__f37 };
			this.__changed = new bool[38];
			this.__isPK = new [] { true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = 0;
		}
		protected override void SetIdentity(int value)
		{
			this.__f0 = value;
		}
		public static SfScreenRevision LoadByPK(Sql sql, Int32 ID)
		{
			sql.Clear();
			sql.AddInput("ID", ID);
			return LoadRecord<SfScreenRevision>(sql, $"SELECT {SelectQuery} WHERE [ID]=@ID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ID"];
			this.__f1 = (String)reader["FUID"];
			this.__f2 = (Int32)reader["ScreenID"];
			this.__f3 = (String)reader["Revision"];
			this.__f4 = (Int16)reader["RevisionStatusID"];
			this.__f5 = (Boolean)reader["IsDefaultRevision"];
			this.__f6 = ToNullable<Int32>(reader["LayoutID"]);
			this.__f7 = ToNullable<Int32>(reader["TitleTextID"]);
			this.__f8 = EmptyToNull(reader["Description"]);
			this.__f9 = EmptyToNull(reader["Instance"]);
			this.__f10 = (Int16)reader["NavigationType"];
			this.__f11 = ToNullable<Boolean>(reader["Landing"]);
			this.__f12 = (Boolean)reader["QuickAccess"];
			this.__f13 = EmptyToNull(reader["OnInitializeOperationCode"]);
			this.__f14 = ToNullable<Int32>(reader["OnInitializeOperationID"]);
			this.__f15 = EmptyToNull(reader["OnLoadOperationCode"]);
			this.__f16 = ToNullable<Int32>(reader["OnLoadOperationID"]);
			this.__f17 = (Int16)reader["SoundEffectType"];
			this.__f18 = EmptyToNull(reader["Properties"]);
			this.__f19 = ToNullable<Int32>(reader["DocumentationID"]);
			this.__f20 = ToNullable<Int32>(reader["HeaderViewID"]);
			this.__f21 = ToNullable<Int32>(reader["HeaderViewRevisionID"]);
			this.__f22 = (Boolean)reader["IsTemplate"];
			this.__f23 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f24 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f25 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f26 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f27 = EmptyToNull(reader["CreatedBy"]);
			this.__f28 = (Boolean)reader["Active"];
			this.__f29 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f30 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f31 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f32 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f33 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f34 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f35 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f36 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f37 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfScreenAction : SqlStampedObject
	{
		public const string SelectQuery = "[ID],[ScreenRevisionID],[Name],[FUID],[NextScreenID],[NextScreenRevisionID],[PopupViewID],[PopupViewRevisionID],[Enabled],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_SCREEN_ACTION]";
		Int32 __f0;
		public Int32 ID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32 __f1;
		public Int32 ScreenRevisionID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		String __f2;
		public String Name
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		String __f3;
		public String FUID
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		Int32? __f4;
		public Int32? NextScreenID
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		Int32? __f5;
		public Int32? NextScreenRevisionID
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		Int32? __f6;
		public Int32? PopupViewID
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Int32? __f7;
		public Int32? PopupViewRevisionID
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		Boolean __f8;
		public Boolean Enabled
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		Int32? __f9;
		public Int32? ReferenceID
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		DateTime? __f10;
		public DateTime? LastUpdateOn
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String LastUpdatedBy
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		DateTime? __f12;
		public DateTime? CreatedOn
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		String __f13;
		public String CreatedBy
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		Boolean __f14;
		public Boolean Active
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		DateTime? __f15;
		public DateTime? LastDeleteOn
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		String __f16;
		public String LastDeletedBy
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		DateTime? __f17;
		public DateTime? LastReactivateOn
		{
			get { return this.__f17; }
			set
			{
				if (this.__f17 == value) return;
				this.__f17 = value; this.__changed[17] = true;
			}
		}
		String __f18;
		public String LastReactivatedBy
		{
			get { return this.__f18; }
			set
			{
				if (this.__f18 == value) return;
				this.__f18 = value; this.__changed[18] = true;
			}
		}
		Int32? __f19;
		public Int32? ArchiveID
		{
			get { return this.__f19; }
			set
			{
				if (this.__f19 == value) return;
				this.__f19 = value; this.__changed[19] = true;
			}
		}
		DateTime? __f20;
		public DateTime? LastArchiveOn
		{
			get { return this.__f20; }
			set
			{
				if (this.__f20 == value) return;
				this.__f20 = value; this.__changed[20] = true;
			}
		}
		String __f21;
		public String LastArchivedBy
		{
			get { return this.__f21; }
			set
			{
				if (this.__f21 == value) return;
				this.__f21 = value; this.__changed[21] = true;
			}
		}
		DateTime? __f22;
		public DateTime? LastRestoreOn
		{
			get { return this.__f22; }
			set
			{
				if (this.__f22 == value) return;
				this.__f22 = value; this.__changed[22] = true;
			}
		}
		String __f23;
		public String LastRestoredBy
		{
			get { return this.__f23; }
			set
			{
				if (this.__f23 == value) return;
				this.__f23 = value; this.__changed[23] = true;
			}
		}
		public SfScreenAction()
		{
			this.__table = "SF_SCREEN_ACTION";
			this.__fields = new [] { "ID","ScreenRevisionID","Name","FUID","NextScreenID","NextScreenRevisionID","PopupViewID","PopupViewRevisionID","Enabled","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16,()=>this.__f17,()=>this.__f18,()=>this.__f19,()=>this.__f20,()=>this.__f21,()=>this.__f22,()=>this.__f23 };
			this.__changed = new bool[24];
			this.__isPK = new [] { true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = 0;
		}
		protected override void SetIdentity(int value)
		{
			this.__f0 = value;
		}
		public static SfScreenAction LoadByPK(Sql sql, Int32 ID)
		{
			sql.Clear();
			sql.AddInput("ID", ID);
			return LoadRecord<SfScreenAction>(sql, $"SELECT {SelectQuery} WHERE [ID]=@ID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ID"];
			this.__f1 = (Int32)reader["ScreenRevisionID"];
			this.__f2 = (String)reader["Name"];
			this.__f3 = (String)reader["FUID"];
			this.__f4 = ToNullable<Int32>(reader["NextScreenID"]);
			this.__f5 = ToNullable<Int32>(reader["NextScreenRevisionID"]);
			this.__f6 = ToNullable<Int32>(reader["PopupViewID"]);
			this.__f7 = ToNullable<Int32>(reader["PopupViewRevisionID"]);
			this.__f8 = (Boolean)reader["Enabled"];
			this.__f9 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f10 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f11 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f12 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f13 = EmptyToNull(reader["CreatedBy"]);
			this.__f14 = (Boolean)reader["Active"];
			this.__f15 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f16 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f17 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f18 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f19 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f20 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f21 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f22 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f23 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfScreenCategory : SqlStampedObject
	{
		public const string SelectQuery = "[ScreenRevisionID],[CategoryID],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_SCREEN_CATEGORY]";
		Int32 __f0;
		public Int32 ScreenRevisionID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32 __f1;
		public Int32 CategoryID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32? __f2;
		public Int32? ReferenceID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		DateTime? __f3;
		public DateTime? LastUpdateOn
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		String __f4;
		public String LastUpdatedBy
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		DateTime? __f5;
		public DateTime? CreatedOn
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		String __f6;
		public String CreatedBy
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Boolean __f7;
		public Boolean Active
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		DateTime? __f8;
		public DateTime? LastDeleteOn
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String LastDeletedBy
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		DateTime? __f10;
		public DateTime? LastReactivateOn
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String LastReactivatedBy
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Int32? __f12;
		public Int32? ArchiveID
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		DateTime? __f13;
		public DateTime? LastArchiveOn
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		String __f14;
		public String LastArchivedBy
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		DateTime? __f15;
		public DateTime? LastRestoreOn
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		String __f16;
		public String LastRestoredBy
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		public SfScreenCategory()
		{
			this.__table = "SF_SCREEN_CATEGORY";
			this.__fields = new [] { "ScreenRevisionID","CategoryID","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16 };
			this.__changed = new bool[17];
			this.__isPK = new [] { true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = -1;
		}
		public static SfScreenCategory LoadByPK(Sql sql, Int32 ScreenRevisionID,Int32 CategoryID)
		{
			sql.Clear();
			sql.AddInput("ScreenRevisionID", ScreenRevisionID);
			sql.AddInput("CategoryID", CategoryID);
			return LoadRecord<SfScreenCategory>(sql, $"SELECT {SelectQuery} WHERE [ScreenRevisionID]=@ScreenRevisionID AND [CategoryID]=@CategoryID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ScreenRevisionID"];
			this.__f1 = (Int32)reader["CategoryID"];
			this.__f2 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f3 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f4 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f5 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f6 = EmptyToNull(reader["CreatedBy"]);
			this.__f7 = (Boolean)reader["Active"];
			this.__f8 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f9 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f10 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f11 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f12 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f13 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f14 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f15 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f16 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfViewRevision : SqlStampedObject
	{
		public const string SelectQuery = "[ID],[FUID],[ViewID],[Revision],[RevisionStatusID],[IsDefaultRevision],[TitleTextID],[Description],[Type_],[ViewOperationCode],[ViewOperationID],[Style],[CssClass],[Properties],[DocumentationID],[IsTemplate],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_VIEW_REVISION]";
		Int32 __f0;
		public Int32 ID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		String __f1;
		public String FUID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32 __f2;
		public Int32 ViewID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		String __f3;
		public String Revision
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		Int16 __f4;
		public Int16 RevisionStatusID
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		Boolean __f5;
		public Boolean IsDefaultRevision
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		Int32? __f6;
		public Int32? TitleTextID
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		String __f7;
		public String Description
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		Int16 __f8;
		public Int16 Type_
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String ViewOperationCode
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		Int32? __f10;
		public Int32? ViewOperationID
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String Style
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		String __f12;
		public String CssClass
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		String __f13;
		public String Properties
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		Int32? __f14;
		public Int32? DocumentationID
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		Boolean __f15;
		public Boolean IsTemplate
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		Int32? __f16;
		public Int32? ReferenceID
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		DateTime? __f17;
		public DateTime? LastUpdateOn
		{
			get { return this.__f17; }
			set
			{
				if (this.__f17 == value) return;
				this.__f17 = value; this.__changed[17] = true;
			}
		}
		String __f18;
		public String LastUpdatedBy
		{
			get { return this.__f18; }
			set
			{
				if (this.__f18 == value) return;
				this.__f18 = value; this.__changed[18] = true;
			}
		}
		DateTime? __f19;
		public DateTime? CreatedOn
		{
			get { return this.__f19; }
			set
			{
				if (this.__f19 == value) return;
				this.__f19 = value; this.__changed[19] = true;
			}
		}
		String __f20;
		public String CreatedBy
		{
			get { return this.__f20; }
			set
			{
				if (this.__f20 == value) return;
				this.__f20 = value; this.__changed[20] = true;
			}
		}
		Boolean __f21;
		public Boolean Active
		{
			get { return this.__f21; }
			set
			{
				if (this.__f21 == value) return;
				this.__f21 = value; this.__changed[21] = true;
			}
		}
		DateTime? __f22;
		public DateTime? LastDeleteOn
		{
			get { return this.__f22; }
			set
			{
				if (this.__f22 == value) return;
				this.__f22 = value; this.__changed[22] = true;
			}
		}
		String __f23;
		public String LastDeletedBy
		{
			get { return this.__f23; }
			set
			{
				if (this.__f23 == value) return;
				this.__f23 = value; this.__changed[23] = true;
			}
		}
		DateTime? __f24;
		public DateTime? LastReactivateOn
		{
			get { return this.__f24; }
			set
			{
				if (this.__f24 == value) return;
				this.__f24 = value; this.__changed[24] = true;
			}
		}
		String __f25;
		public String LastReactivatedBy
		{
			get { return this.__f25; }
			set
			{
				if (this.__f25 == value) return;
				this.__f25 = value; this.__changed[25] = true;
			}
		}
		Int32? __f26;
		public Int32? ArchiveID
		{
			get { return this.__f26; }
			set
			{
				if (this.__f26 == value) return;
				this.__f26 = value; this.__changed[26] = true;
			}
		}
		DateTime? __f27;
		public DateTime? LastArchiveOn
		{
			get { return this.__f27; }
			set
			{
				if (this.__f27 == value) return;
				this.__f27 = value; this.__changed[27] = true;
			}
		}
		String __f28;
		public String LastArchivedBy
		{
			get { return this.__f28; }
			set
			{
				if (this.__f28 == value) return;
				this.__f28 = value; this.__changed[28] = true;
			}
		}
		DateTime? __f29;
		public DateTime? LastRestoreOn
		{
			get { return this.__f29; }
			set
			{
				if (this.__f29 == value) return;
				this.__f29 = value; this.__changed[29] = true;
			}
		}
		String __f30;
		public String LastRestoredBy
		{
			get { return this.__f30; }
			set
			{
				if (this.__f30 == value) return;
				this.__f30 = value; this.__changed[30] = true;
			}
		}
		public SfViewRevision()
		{
			this.__table = "SF_VIEW_REVISION";
			this.__fields = new [] { "ID","FUID","ViewID","Revision","RevisionStatusID","IsDefaultRevision","TitleTextID","Description","Type_","ViewOperationCode","ViewOperationID","Style","CssClass","Properties","DocumentationID","IsTemplate","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16,()=>this.__f17,()=>this.__f18,()=>this.__f19,()=>this.__f20,()=>this.__f21,()=>this.__f22,()=>this.__f23,()=>this.__f24,()=>this.__f25,()=>this.__f26,()=>this.__f27,()=>this.__f28,()=>this.__f29,()=>this.__f30 };
			this.__changed = new bool[31];
			this.__isPK = new [] { true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = 0;
		}
		protected override void SetIdentity(int value)
		{
			this.__f0 = value;
		}
		public static SfViewRevision LoadByPK(Sql sql, Int32 ID)
		{
			sql.Clear();
			sql.AddInput("ID", ID);
			return LoadRecord<SfViewRevision>(sql, $"SELECT {SelectQuery} WHERE [ID]=@ID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ID"];
			this.__f1 = (String)reader["FUID"];
			this.__f2 = (Int32)reader["ViewID"];
			this.__f3 = (String)reader["Revision"];
			this.__f4 = (Int16)reader["RevisionStatusID"];
			this.__f5 = (Boolean)reader["IsDefaultRevision"];
			this.__f6 = ToNullable<Int32>(reader["TitleTextID"]);
			this.__f7 = EmptyToNull(reader["Description"]);
			this.__f8 = (Int16)reader["Type_"];
			this.__f9 = EmptyToNull(reader["ViewOperationCode"]);
			this.__f10 = ToNullable<Int32>(reader["ViewOperationID"]);
			this.__f11 = EmptyToNull(reader["Style"]);
			this.__f12 = EmptyToNull(reader["CssClass"]);
			this.__f13 = EmptyToNull(reader["Properties"]);
			this.__f14 = ToNullable<Int32>(reader["DocumentationID"]);
			this.__f15 = (Boolean)reader["IsTemplate"];
			this.__f16 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f17 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f18 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f19 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f20 = EmptyToNull(reader["CreatedBy"]);
			this.__f21 = (Boolean)reader["Active"];
			this.__f22 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f23 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f24 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f25 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f26 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f27 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f28 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f29 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f30 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfLayerType : SqlStampedObject
	{
		public const string SelectQuery = "[LayerType],[TextID],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_LAYER_TYPE]";
		Int16 __f0;
		public Int16 LayerType
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32? __f1;
		public Int32? TextID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32? __f2;
		public Int32? ReferenceID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		DateTime? __f3;
		public DateTime? LastUpdateOn
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		String __f4;
		public String LastUpdatedBy
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		DateTime? __f5;
		public DateTime? CreatedOn
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		String __f6;
		public String CreatedBy
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Boolean __f7;
		public Boolean Active
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		DateTime? __f8;
		public DateTime? LastDeleteOn
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String LastDeletedBy
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		DateTime? __f10;
		public DateTime? LastReactivateOn
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String LastReactivatedBy
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Int32? __f12;
		public Int32? ArchiveID
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		DateTime? __f13;
		public DateTime? LastArchiveOn
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		String __f14;
		public String LastArchivedBy
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		DateTime? __f15;
		public DateTime? LastRestoreOn
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		String __f16;
		public String LastRestoredBy
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		public SfLayerType()
		{
			this.__table = "SF_LAYER_TYPE";
			this.__fields = new [] { "LayerType","TextID","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16 };
			this.__changed = new bool[17];
			this.__isPK = new [] { true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = -1;
		}
		public static SfLayerType LoadByPK(Sql sql, Int16 LayerType)
		{
			sql.Clear();
			sql.AddInput("LayerType", LayerType);
			return LoadRecord<SfLayerType>(sql, $"SELECT {SelectQuery} WHERE [LayerType]=@LayerType");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int16)reader["LayerType"];
			this.__f1 = ToNullable<Int32>(reader["TextID"]);
			this.__f2 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f3 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f4 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f5 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f6 = EmptyToNull(reader["CreatedBy"]);
			this.__f7 = (Boolean)reader["Active"];
			this.__f8 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f9 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f10 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f11 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f12 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f13 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f14 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f15 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f16 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfScreenRole : SqlStampedObject
	{
		public const string SelectQuery = "[ScreenRevisionID],[RoleID],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_SCREEN_ROLE]";
		Int32 __f0;
		public Int32 ScreenRevisionID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32 __f1;
		public Int32 RoleID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32? __f2;
		public Int32? ReferenceID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		DateTime? __f3;
		public DateTime? LastUpdateOn
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		String __f4;
		public String LastUpdatedBy
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		DateTime? __f5;
		public DateTime? CreatedOn
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		String __f6;
		public String CreatedBy
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Boolean __f7;
		public Boolean Active
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		DateTime? __f8;
		public DateTime? LastDeleteOn
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String LastDeletedBy
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		DateTime? __f10;
		public DateTime? LastReactivateOn
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String LastReactivatedBy
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Int32? __f12;
		public Int32? ArchiveID
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		DateTime? __f13;
		public DateTime? LastArchiveOn
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		String __f14;
		public String LastArchivedBy
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		DateTime? __f15;
		public DateTime? LastRestoreOn
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		String __f16;
		public String LastRestoredBy
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		public SfScreenRole()
		{
			this.__table = "SF_SCREEN_ROLE";
			this.__fields = new [] { "ScreenRevisionID","RoleID","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16 };
			this.__changed = new bool[17];
			this.__isPK = new [] { true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = -1;
		}
		public static SfScreenRole LoadByPK(Sql sql, Int32 ScreenRevisionID,Int32 RoleID)
		{
			sql.Clear();
			sql.AddInput("ScreenRevisionID", ScreenRevisionID);
			sql.AddInput("RoleID", RoleID);
			return LoadRecord<SfScreenRole>(sql, $"SELECT {SelectQuery} WHERE [ScreenRevisionID]=@ScreenRevisionID AND [RoleID]=@RoleID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ScreenRevisionID"];
			this.__f1 = (Int32)reader["RoleID"];
			this.__f2 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f3 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f4 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f5 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f6 = EmptyToNull(reader["CreatedBy"]);
			this.__f7 = (Boolean)reader["Active"];
			this.__f8 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f9 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f10 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f11 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f12 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f13 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f14 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f15 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f16 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfScreenPanel : SqlStampedObject
	{
		public const string SelectQuery = "[ID],[FUID],[ScreenRevisionID],[PanelID],[ViewID],[ViewRevisionID],[TitleTextID],[Refresh],[UseDefaultViewFromLayout],[DefaultActionName],[IsChangeView],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_SCREEN_PANEL]";
		Int32 __f0;
		public Int32 ID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		String __f1;
		public String FUID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32 __f2;
		public Int32 ScreenRevisionID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		Int32? __f3;
		public Int32? PanelID
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		Int32? __f4;
		public Int32? ViewID
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		Int32? __f5;
		public Int32? ViewRevisionID
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		Int32? __f6;
		public Int32? TitleTextID
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Int32 __f7;
		public Int32 Refresh
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		Boolean __f8;
		public Boolean UseDefaultViewFromLayout
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String DefaultActionName
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		Boolean __f10;
		public Boolean IsChangeView
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		Int32? __f11;
		public Int32? ReferenceID
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		DateTime? __f12;
		public DateTime? LastUpdateOn
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		String __f13;
		public String LastUpdatedBy
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		DateTime? __f14;
		public DateTime? CreatedOn
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		String __f15;
		public String CreatedBy
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		Boolean __f16;
		public Boolean Active
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		DateTime? __f17;
		public DateTime? LastDeleteOn
		{
			get { return this.__f17; }
			set
			{
				if (this.__f17 == value) return;
				this.__f17 = value; this.__changed[17] = true;
			}
		}
		String __f18;
		public String LastDeletedBy
		{
			get { return this.__f18; }
			set
			{
				if (this.__f18 == value) return;
				this.__f18 = value; this.__changed[18] = true;
			}
		}
		DateTime? __f19;
		public DateTime? LastReactivateOn
		{
			get { return this.__f19; }
			set
			{
				if (this.__f19 == value) return;
				this.__f19 = value; this.__changed[19] = true;
			}
		}
		String __f20;
		public String LastReactivatedBy
		{
			get { return this.__f20; }
			set
			{
				if (this.__f20 == value) return;
				this.__f20 = value; this.__changed[20] = true;
			}
		}
		Int32? __f21;
		public Int32? ArchiveID
		{
			get { return this.__f21; }
			set
			{
				if (this.__f21 == value) return;
				this.__f21 = value; this.__changed[21] = true;
			}
		}
		DateTime? __f22;
		public DateTime? LastArchiveOn
		{
			get { return this.__f22; }
			set
			{
				if (this.__f22 == value) return;
				this.__f22 = value; this.__changed[22] = true;
			}
		}
		String __f23;
		public String LastArchivedBy
		{
			get { return this.__f23; }
			set
			{
				if (this.__f23 == value) return;
				this.__f23 = value; this.__changed[23] = true;
			}
		}
		DateTime? __f24;
		public DateTime? LastRestoreOn
		{
			get { return this.__f24; }
			set
			{
				if (this.__f24 == value) return;
				this.__f24 = value; this.__changed[24] = true;
			}
		}
		String __f25;
		public String LastRestoredBy
		{
			get { return this.__f25; }
			set
			{
				if (this.__f25 == value) return;
				this.__f25 = value; this.__changed[25] = true;
			}
		}
		public SfScreenPanel()
		{
			this.__table = "SF_SCREEN_PANEL";
			this.__fields = new [] { "ID","FUID","ScreenRevisionID","PanelID","ViewID","ViewRevisionID","TitleTextID","Refresh","UseDefaultViewFromLayout","DefaultActionName","IsChangeView","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16,()=>this.__f17,()=>this.__f18,()=>this.__f19,()=>this.__f20,()=>this.__f21,()=>this.__f22,()=>this.__f23,()=>this.__f24,()=>this.__f25 };
			this.__changed = new bool[26];
			this.__isPK = new [] { true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = 0;
		}
		protected override void SetIdentity(int value)
		{
			this.__f0 = value;
		}
		public static SfScreenPanel LoadByPK(Sql sql, Int32 ID)
		{
			sql.Clear();
			sql.AddInput("ID", ID);
			return LoadRecord<SfScreenPanel>(sql, $"SELECT {SelectQuery} WHERE [ID]=@ID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ID"];
			this.__f1 = (String)reader["FUID"];
			this.__f2 = (Int32)reader["ScreenRevisionID"];
			this.__f3 = ToNullable<Int32>(reader["PanelID"]);
			this.__f4 = ToNullable<Int32>(reader["ViewID"]);
			this.__f5 = ToNullable<Int32>(reader["ViewRevisionID"]);
			this.__f6 = ToNullable<Int32>(reader["TitleTextID"]);
			this.__f7 = (Int32)reader["Refresh"];
			this.__f8 = (Boolean)reader["UseDefaultViewFromLayout"];
			this.__f9 = EmptyToNull(reader["DefaultActionName"]);
			this.__f10 = (Boolean)reader["IsChangeView"];
			this.__f11 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f12 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f13 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f14 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f15 = EmptyToNull(reader["CreatedBy"]);
			this.__f16 = (Boolean)reader["Active"];
			this.__f17 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f18 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f19 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f20 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f21 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f22 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f23 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f24 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f25 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfScreenPanelAction : SqlStampedObject
	{
		public const string SelectQuery = "[ID],[FUID],[ScreenPanelID],[Name],[OverrideAction],[PositionOrder],[Type],[TitleTextID],[ShowTitle],[OnActionOperationCode],[OnActionOperationID],[TargetScreenType],[NextActionName],[NextScreenID],[NextScreenRevisionID],[PopupViewID],[PopupViewRevisionID],[GroupTag],[Keyboard],[Style],[CssClass],[Image],[AvailabilityMode],[Properties],[Enabled],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_SCREEN_PANEL_ACTION]";
		Int32 __f0;
		public Int32 ID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		String __f1;
		public String FUID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32 __f2;
		public Int32 ScreenPanelID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		String __f3;
		public String Name
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		Boolean __f4;
		public Boolean OverrideAction
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		Int32 __f5;
		public Int32 PositionOrder
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		Int16 __f6;
		public Int16 Type
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Int32? __f7;
		public Int32? TitleTextID
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		Boolean __f8;
		public Boolean ShowTitle
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String OnActionOperationCode
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		Int32? __f10;
		public Int32? OnActionOperationID
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		Int16 __f11;
		public Int16 TargetScreenType
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		String __f12;
		public String NextActionName
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		Int32? __f13;
		public Int32? NextScreenID
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		Int32? __f14;
		public Int32? NextScreenRevisionID
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		Int32? __f15;
		public Int32? PopupViewID
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		Int32? __f16;
		public Int32? PopupViewRevisionID
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		String __f17;
		public String GroupTag
		{
			get { return this.__f17; }
			set
			{
				if (this.__f17 == value) return;
				this.__f17 = value; this.__changed[17] = true;
			}
		}
		Int16? __f18;
		public Int16? Keyboard
		{
			get { return this.__f18; }
			set
			{
				if (this.__f18 == value) return;
				this.__f18 = value; this.__changed[18] = true;
			}
		}
		String __f19;
		public String Style
		{
			get { return this.__f19; }
			set
			{
				if (this.__f19 == value) return;
				this.__f19 = value; this.__changed[19] = true;
			}
		}
		String __f20;
		public String CssClass
		{
			get { return this.__f20; }
			set
			{
				if (this.__f20 == value) return;
				this.__f20 = value; this.__changed[20] = true;
			}
		}
		String __f21;
		public String Image
		{
			get { return this.__f21; }
			set
			{
				if (this.__f21 == value) return;
				this.__f21 = value; this.__changed[21] = true;
			}
		}
		Int16 __f22;
		public Int16 AvailabilityMode
		{
			get { return this.__f22; }
			set
			{
				if (this.__f22 == value) return;
				this.__f22 = value; this.__changed[22] = true;
			}
		}
		String __f23;
		public String Properties
		{
			get { return this.__f23; }
			set
			{
				if (this.__f23 == value) return;
				this.__f23 = value; this.__changed[23] = true;
			}
		}
		Boolean __f24;
		public Boolean Enabled
		{
			get { return this.__f24; }
			set
			{
				if (this.__f24 == value) return;
				this.__f24 = value; this.__changed[24] = true;
			}
		}
		Int32? __f25;
		public Int32? ReferenceID
		{
			get { return this.__f25; }
			set
			{
				if (this.__f25 == value) return;
				this.__f25 = value; this.__changed[25] = true;
			}
		}
		DateTime? __f26;
		public DateTime? LastUpdateOn
		{
			get { return this.__f26; }
			set
			{
				if (this.__f26 == value) return;
				this.__f26 = value; this.__changed[26] = true;
			}
		}
		String __f27;
		public String LastUpdatedBy
		{
			get { return this.__f27; }
			set
			{
				if (this.__f27 == value) return;
				this.__f27 = value; this.__changed[27] = true;
			}
		}
		DateTime? __f28;
		public DateTime? CreatedOn
		{
			get { return this.__f28; }
			set
			{
				if (this.__f28 == value) return;
				this.__f28 = value; this.__changed[28] = true;
			}
		}
		String __f29;
		public String CreatedBy
		{
			get { return this.__f29; }
			set
			{
				if (this.__f29 == value) return;
				this.__f29 = value; this.__changed[29] = true;
			}
		}
		Boolean __f30;
		public Boolean Active
		{
			get { return this.__f30; }
			set
			{
				if (this.__f30 == value) return;
				this.__f30 = value; this.__changed[30] = true;
			}
		}
		DateTime? __f31;
		public DateTime? LastDeleteOn
		{
			get { return this.__f31; }
			set
			{
				if (this.__f31 == value) return;
				this.__f31 = value; this.__changed[31] = true;
			}
		}
		String __f32;
		public String LastDeletedBy
		{
			get { return this.__f32; }
			set
			{
				if (this.__f32 == value) return;
				this.__f32 = value; this.__changed[32] = true;
			}
		}
		DateTime? __f33;
		public DateTime? LastReactivateOn
		{
			get { return this.__f33; }
			set
			{
				if (this.__f33 == value) return;
				this.__f33 = value; this.__changed[33] = true;
			}
		}
		String __f34;
		public String LastReactivatedBy
		{
			get { return this.__f34; }
			set
			{
				if (this.__f34 == value) return;
				this.__f34 = value; this.__changed[34] = true;
			}
		}
		Int32? __f35;
		public Int32? ArchiveID
		{
			get { return this.__f35; }
			set
			{
				if (this.__f35 == value) return;
				this.__f35 = value; this.__changed[35] = true;
			}
		}
		DateTime? __f36;
		public DateTime? LastArchiveOn
		{
			get { return this.__f36; }
			set
			{
				if (this.__f36 == value) return;
				this.__f36 = value; this.__changed[36] = true;
			}
		}
		String __f37;
		public String LastArchivedBy
		{
			get { return this.__f37; }
			set
			{
				if (this.__f37 == value) return;
				this.__f37 = value; this.__changed[37] = true;
			}
		}
		DateTime? __f38;
		public DateTime? LastRestoreOn
		{
			get { return this.__f38; }
			set
			{
				if (this.__f38 == value) return;
				this.__f38 = value; this.__changed[38] = true;
			}
		}
		String __f39;
		public String LastRestoredBy
		{
			get { return this.__f39; }
			set
			{
				if (this.__f39 == value) return;
				this.__f39 = value; this.__changed[39] = true;
			}
		}
		public SfScreenPanelAction()
		{
			this.__table = "SF_SCREEN_PANEL_ACTION";
			this.__fields = new [] { "ID","FUID","ScreenPanelID","Name","OverrideAction","PositionOrder","Type","TitleTextID","ShowTitle","OnActionOperationCode","OnActionOperationID","TargetScreenType","NextActionName","NextScreenID","NextScreenRevisionID","PopupViewID","PopupViewRevisionID","GroupTag","Keyboard","Style","CssClass","Image","AvailabilityMode","Properties","Enabled","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16,()=>this.__f17,()=>this.__f18,()=>this.__f19,()=>this.__f20,()=>this.__f21,()=>this.__f22,()=>this.__f23,()=>this.__f24,()=>this.__f25,()=>this.__f26,()=>this.__f27,()=>this.__f28,()=>this.__f29,()=>this.__f30,()=>this.__f31,()=>this.__f32,()=>this.__f33,()=>this.__f34,()=>this.__f35,()=>this.__f36,()=>this.__f37,()=>this.__f38,()=>this.__f39 };
			this.__changed = new bool[40];
			this.__isPK = new [] { true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = 0;
		}
		protected override void SetIdentity(int value)
		{
			this.__f0 = value;
		}
		public static SfScreenPanelAction LoadByPK(Sql sql, Int32 ID)
		{
			sql.Clear();
			sql.AddInput("ID", ID);
			return LoadRecord<SfScreenPanelAction>(sql, $"SELECT {SelectQuery} WHERE [ID]=@ID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ID"];
			this.__f1 = (String)reader["FUID"];
			this.__f2 = (Int32)reader["ScreenPanelID"];
			this.__f3 = (String)reader["Name"];
			this.__f4 = (Boolean)reader["OverrideAction"];
			this.__f5 = (Int32)reader["PositionOrder"];
			this.__f6 = (Int16)reader["Type"];
			this.__f7 = ToNullable<Int32>(reader["TitleTextID"]);
			this.__f8 = (Boolean)reader["ShowTitle"];
			this.__f9 = EmptyToNull(reader["OnActionOperationCode"]);
			this.__f10 = ToNullable<Int32>(reader["OnActionOperationID"]);
			this.__f11 = (Int16)reader["TargetScreenType"];
			this.__f12 = EmptyToNull(reader["NextActionName"]);
			this.__f13 = ToNullable<Int32>(reader["NextScreenID"]);
			this.__f14 = ToNullable<Int32>(reader["NextScreenRevisionID"]);
			this.__f15 = ToNullable<Int32>(reader["PopupViewID"]);
			this.__f16 = ToNullable<Int32>(reader["PopupViewRevisionID"]);
			this.__f17 = EmptyToNull(reader["GroupTag"]);
			this.__f18 = ToNullable<Int16>(reader["Keyboard"]);
			this.__f19 = EmptyToNull(reader["Style"]);
			this.__f20 = EmptyToNull(reader["CssClass"]);
			this.__f21 = EmptyToNull(reader["Image"]);
			this.__f22 = (Int16)reader["AvailabilityMode"];
			this.__f23 = EmptyToNull(reader["Properties"]);
			this.__f24 = (Boolean)reader["Enabled"];
			this.__f25 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f26 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f27 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f28 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f29 = EmptyToNull(reader["CreatedBy"]);
			this.__f30 = (Boolean)reader["Active"];
			this.__f31 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f32 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f33 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f34 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f35 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f36 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f37 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f38 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f39 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfLayout : SqlStampedObject
	{
		public const string SelectQuery = "[ID],[Name],[RootPanelID],[Description],[RevisionStatusID],[DocumentationID],[HeaderViewID],[HeaderViewRevisionID],[IsTemplate],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_LAYOUT]";
		Int32 __f0;
		public Int32 ID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		String __f1;
		public String Name
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32? __f2;
		public Int32? RootPanelID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		String __f3;
		public String Description
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		Int16 __f4;
		public Int16 RevisionStatusID
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		Int32? __f5;
		public Int32? DocumentationID
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		Int32? __f6;
		public Int32? HeaderViewID
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Int32? __f7;
		public Int32? HeaderViewRevisionID
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		Boolean __f8;
		public Boolean IsTemplate
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		Int32? __f9;
		public Int32? ReferenceID
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		DateTime? __f10;
		public DateTime? LastUpdateOn
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String LastUpdatedBy
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		DateTime? __f12;
		public DateTime? CreatedOn
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		String __f13;
		public String CreatedBy
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		Boolean __f14;
		public Boolean Active
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		DateTime? __f15;
		public DateTime? LastDeleteOn
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		String __f16;
		public String LastDeletedBy
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		DateTime? __f17;
		public DateTime? LastReactivateOn
		{
			get { return this.__f17; }
			set
			{
				if (this.__f17 == value) return;
				this.__f17 = value; this.__changed[17] = true;
			}
		}
		String __f18;
		public String LastReactivatedBy
		{
			get { return this.__f18; }
			set
			{
				if (this.__f18 == value) return;
				this.__f18 = value; this.__changed[18] = true;
			}
		}
		Int32? __f19;
		public Int32? ArchiveID
		{
			get { return this.__f19; }
			set
			{
				if (this.__f19 == value) return;
				this.__f19 = value; this.__changed[19] = true;
			}
		}
		DateTime? __f20;
		public DateTime? LastArchiveOn
		{
			get { return this.__f20; }
			set
			{
				if (this.__f20 == value) return;
				this.__f20 = value; this.__changed[20] = true;
			}
		}
		String __f21;
		public String LastArchivedBy
		{
			get { return this.__f21; }
			set
			{
				if (this.__f21 == value) return;
				this.__f21 = value; this.__changed[21] = true;
			}
		}
		DateTime? __f22;
		public DateTime? LastRestoreOn
		{
			get { return this.__f22; }
			set
			{
				if (this.__f22 == value) return;
				this.__f22 = value; this.__changed[22] = true;
			}
		}
		String __f23;
		public String LastRestoredBy
		{
			get { return this.__f23; }
			set
			{
				if (this.__f23 == value) return;
				this.__f23 = value; this.__changed[23] = true;
			}
		}
		public SfLayout()
		{
			this.__table = "SF_LAYOUT";
			this.__fields = new [] { "ID","Name","RootPanelID","Description","RevisionStatusID","DocumentationID","HeaderViewID","HeaderViewRevisionID","IsTemplate","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16,()=>this.__f17,()=>this.__f18,()=>this.__f19,()=>this.__f20,()=>this.__f21,()=>this.__f22,()=>this.__f23 };
			this.__changed = new bool[24];
			this.__isPK = new [] { true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = 0;
		}
		protected override void SetIdentity(int value)
		{
			this.__f0 = value;
		}
		public static SfLayout LoadByPK(Sql sql, Int32 ID)
		{
			sql.Clear();
			sql.AddInput("ID", ID);
			return LoadRecord<SfLayout>(sql, $"SELECT {SelectQuery} WHERE [ID]=@ID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ID"];
			this.__f1 = (String)reader["Name"];
			this.__f2 = ToNullable<Int32>(reader["RootPanelID"]);
			this.__f3 = EmptyToNull(reader["Description"]);
			this.__f4 = (Int16)reader["RevisionStatusID"];
			this.__f5 = ToNullable<Int32>(reader["DocumentationID"]);
			this.__f6 = ToNullable<Int32>(reader["HeaderViewID"]);
			this.__f7 = ToNullable<Int32>(reader["HeaderViewRevisionID"]);
			this.__f8 = (Boolean)reader["IsTemplate"];
			this.__f9 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f10 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f11 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f12 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f13 = EmptyToNull(reader["CreatedBy"]);
			this.__f14 = (Boolean)reader["Active"];
			this.__f15 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f16 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f17 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f18 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f19 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f20 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f21 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f22 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f23 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfView : SqlStampedObject
	{
		public const string SelectQuery = "[ID],[FUID],[Name],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_VIEW]";
		Int32 __f0;
		public Int32 ID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		String __f1;
		public String FUID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		String __f2;
		public String Name
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		Int32? __f3;
		public Int32? ReferenceID
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		DateTime? __f4;
		public DateTime? LastUpdateOn
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		String __f5;
		public String LastUpdatedBy
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		DateTime? __f6;
		public DateTime? CreatedOn
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		String __f7;
		public String CreatedBy
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		Boolean __f8;
		public Boolean Active
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		DateTime? __f9;
		public DateTime? LastDeleteOn
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		String __f10;
		public String LastDeletedBy
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		DateTime? __f11;
		public DateTime? LastReactivateOn
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		String __f12;
		public String LastReactivatedBy
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		Int32? __f13;
		public Int32? ArchiveID
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		DateTime? __f14;
		public DateTime? LastArchiveOn
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		String __f15;
		public String LastArchivedBy
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		DateTime? __f16;
		public DateTime? LastRestoreOn
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		String __f17;
		public String LastRestoredBy
		{
			get { return this.__f17; }
			set
			{
				if (this.__f17 == value) return;
				this.__f17 = value; this.__changed[17] = true;
			}
		}
		public SfView()
		{
			this.__table = "SF_VIEW";
			this.__fields = new [] { "ID","FUID","Name","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16,()=>this.__f17 };
			this.__changed = new bool[18];
			this.__isPK = new [] { true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = 0;
		}
		protected override void SetIdentity(int value)
		{
			this.__f0 = value;
		}
		public static SfView LoadByPK(Sql sql, Int32 ID)
		{
			sql.Clear();
			sql.AddInput("ID", ID);
			return LoadRecord<SfView>(sql, $"SELECT {SelectQuery} WHERE [ID]=@ID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ID"];
			this.__f1 = (String)reader["FUID"];
			this.__f2 = (String)reader["Name"];
			this.__f3 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f4 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f5 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f6 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f7 = EmptyToNull(reader["CreatedBy"]);
			this.__f8 = (Boolean)reader["Active"];
			this.__f9 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f10 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f11 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f12 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f13 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f14 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f15 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f16 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f17 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfScreenPanelActionParam : SqlStampedObject
	{
		public const string SelectQuery = "[ScreenPanelActionID],[ParameterID],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_SCREEN_PANEL_ACTION_PARAM]";
		Int32 __f0;
		public Int32 ScreenPanelActionID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32 __f1;
		public Int32 ParameterID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32? __f2;
		public Int32? ReferenceID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		DateTime? __f3;
		public DateTime? LastUpdateOn
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		String __f4;
		public String LastUpdatedBy
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		DateTime? __f5;
		public DateTime? CreatedOn
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		String __f6;
		public String CreatedBy
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Boolean __f7;
		public Boolean Active
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		DateTime? __f8;
		public DateTime? LastDeleteOn
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String LastDeletedBy
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		DateTime? __f10;
		public DateTime? LastReactivateOn
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String LastReactivatedBy
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Int32? __f12;
		public Int32? ArchiveID
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		DateTime? __f13;
		public DateTime? LastArchiveOn
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		String __f14;
		public String LastArchivedBy
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		DateTime? __f15;
		public DateTime? LastRestoreOn
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		String __f16;
		public String LastRestoredBy
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		public SfScreenPanelActionParam()
		{
			this.__table = "SF_SCREEN_PANEL_ACTION_PARAM";
			this.__fields = new [] { "ScreenPanelActionID","ParameterID","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16 };
			this.__changed = new bool[17];
			this.__isPK = new [] { true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = -1;
		}
		public static SfScreenPanelActionParam LoadByPK(Sql sql, Int32 ScreenPanelActionID,Int32 ParameterID)
		{
			sql.Clear();
			sql.AddInput("ScreenPanelActionID", ScreenPanelActionID);
			sql.AddInput("ParameterID", ParameterID);
			return LoadRecord<SfScreenPanelActionParam>(sql, $"SELECT {SelectQuery} WHERE [ScreenPanelActionID]=@ScreenPanelActionID AND [ParameterID]=@ParameterID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ScreenPanelActionID"];
			this.__f1 = (Int32)reader["ParameterID"];
			this.__f2 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f3 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f4 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f5 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f6 = EmptyToNull(reader["CreatedBy"]);
			this.__f7 = (Boolean)reader["Active"];
			this.__f8 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f9 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f10 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f11 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f12 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f13 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f14 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f15 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f16 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfLayoutCategory : SqlStampedObject
	{
		public const string SelectQuery = "[LayoutID],[CategoryID],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_LAYOUT_CATEGORY]";
		Int32 __f0;
		public Int32 LayoutID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32 __f1;
		public Int32 CategoryID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32? __f2;
		public Int32? ReferenceID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		DateTime? __f3;
		public DateTime? LastUpdateOn
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		String __f4;
		public String LastUpdatedBy
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		DateTime? __f5;
		public DateTime? CreatedOn
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		String __f6;
		public String CreatedBy
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Boolean __f7;
		public Boolean Active
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		DateTime? __f8;
		public DateTime? LastDeleteOn
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String LastDeletedBy
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		DateTime? __f10;
		public DateTime? LastReactivateOn
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String LastReactivatedBy
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Int32? __f12;
		public Int32? ArchiveID
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		DateTime? __f13;
		public DateTime? LastArchiveOn
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		String __f14;
		public String LastArchivedBy
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		DateTime? __f15;
		public DateTime? LastRestoreOn
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		String __f16;
		public String LastRestoredBy
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		public SfLayoutCategory()
		{
			this.__table = "SF_LAYOUT_CATEGORY";
			this.__fields = new [] { "LayoutID","CategoryID","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16 };
			this.__changed = new bool[17];
			this.__isPK = new [] { true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = -1;
		}
		public static SfLayoutCategory LoadByPK(Sql sql, Int32 LayoutID,Int32 CategoryID)
		{
			sql.Clear();
			sql.AddInput("LayoutID", LayoutID);
			sql.AddInput("CategoryID", CategoryID);
			return LoadRecord<SfLayoutCategory>(sql, $"SELECT {SelectQuery} WHERE [LayoutID]=@LayoutID AND [CategoryID]=@CategoryID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["LayoutID"];
			this.__f1 = (Int32)reader["CategoryID"];
			this.__f2 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f3 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f4 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f5 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f6 = EmptyToNull(reader["CreatedBy"]);
			this.__f7 = (Boolean)reader["Active"];
			this.__f8 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f9 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f10 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f11 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f12 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f13 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f14 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f15 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f16 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfScreenPanelActionRole : SqlStampedObject
	{
		public const string SelectQuery = "[ScreenPanelActionID],[RoleID],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_SCREEN_PANEL_ACTION_ROLE]";
		Int32 __f0;
		public Int32 ScreenPanelActionID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32 __f1;
		public Int32 RoleID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32? __f2;
		public Int32? ReferenceID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		DateTime? __f3;
		public DateTime? LastUpdateOn
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		String __f4;
		public String LastUpdatedBy
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		DateTime? __f5;
		public DateTime? CreatedOn
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		String __f6;
		public String CreatedBy
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Boolean __f7;
		public Boolean Active
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		DateTime? __f8;
		public DateTime? LastDeleteOn
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String LastDeletedBy
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		DateTime? __f10;
		public DateTime? LastReactivateOn
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String LastReactivatedBy
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Int32? __f12;
		public Int32? ArchiveID
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		DateTime? __f13;
		public DateTime? LastArchiveOn
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		String __f14;
		public String LastArchivedBy
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		DateTime? __f15;
		public DateTime? LastRestoreOn
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		String __f16;
		public String LastRestoredBy
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		public SfScreenPanelActionRole()
		{
			this.__table = "SF_SCREEN_PANEL_ACTION_ROLE";
			this.__fields = new [] { "ScreenPanelActionID","RoleID","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16 };
			this.__changed = new bool[17];
			this.__isPK = new [] { true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = -1;
		}
		public static SfScreenPanelActionRole LoadByPK(Sql sql, Int32 ScreenPanelActionID,Int32 RoleID)
		{
			sql.Clear();
			sql.AddInput("ScreenPanelActionID", ScreenPanelActionID);
			sql.AddInput("RoleID", RoleID);
			return LoadRecord<SfScreenPanelActionRole>(sql, $"SELECT {SelectQuery} WHERE [ScreenPanelActionID]=@ScreenPanelActionID AND [RoleID]=@RoleID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ScreenPanelActionID"];
			this.__f1 = (Int32)reader["RoleID"];
			this.__f2 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f3 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f4 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f5 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f6 = EmptyToNull(reader["CreatedBy"]);
			this.__f7 = (Boolean)reader["Active"];
			this.__f8 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f9 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f10 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f11 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f12 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f13 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f14 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f15 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f16 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfViewAction : SqlStampedObject
	{
		public const string SelectQuery = "[ID],[ViewRevisionID],[Name],[FUID],[Defined],[PositionOrder],[Type],[TitleTextID],[ShowTitle],[OnActionOperationCode],[OnActionOperationID],[NextViewAction],[TargetScreenType],[TargetScreenID],[TargetScreenRevisionID],[PopupViewID],[PopupViewRevisionID],[GroupTag],[Keyboard],[Style],[CssClass],[Image],[AvailabilityMode],[Properties],[Enabled],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_VIEW_ACTION]";
		Int32 __f0;
		public Int32 ID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32 __f1;
		public Int32 ViewRevisionID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		String __f2;
		public String Name
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		String __f3;
		public String FUID
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		Boolean __f4;
		public Boolean Defined
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		Int32 __f5;
		public Int32 PositionOrder
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		Int16 __f6;
		public Int16 Type
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Int32? __f7;
		public Int32? TitleTextID
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		Boolean __f8;
		public Boolean ShowTitle
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String OnActionOperationCode
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		Int32? __f10;
		public Int32? OnActionOperationID
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String NextViewAction
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Int16 __f12;
		public Int16 TargetScreenType
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		Int32? __f13;
		public Int32? TargetScreenID
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		Int32? __f14;
		public Int32? TargetScreenRevisionID
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		Int32? __f15;
		public Int32? PopupViewID
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		Int32? __f16;
		public Int32? PopupViewRevisionID
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		String __f17;
		public String GroupTag
		{
			get { return this.__f17; }
			set
			{
				if (this.__f17 == value) return;
				this.__f17 = value; this.__changed[17] = true;
			}
		}
		Int16? __f18;
		public Int16? Keyboard
		{
			get { return this.__f18; }
			set
			{
				if (this.__f18 == value) return;
				this.__f18 = value; this.__changed[18] = true;
			}
		}
		String __f19;
		public String Style
		{
			get { return this.__f19; }
			set
			{
				if (this.__f19 == value) return;
				this.__f19 = value; this.__changed[19] = true;
			}
		}
		String __f20;
		public String CssClass
		{
			get { return this.__f20; }
			set
			{
				if (this.__f20 == value) return;
				this.__f20 = value; this.__changed[20] = true;
			}
		}
		String __f21;
		public String Image
		{
			get { return this.__f21; }
			set
			{
				if (this.__f21 == value) return;
				this.__f21 = value; this.__changed[21] = true;
			}
		}
		Int16 __f22;
		public Int16 AvailabilityMode
		{
			get { return this.__f22; }
			set
			{
				if (this.__f22 == value) return;
				this.__f22 = value; this.__changed[22] = true;
			}
		}
		String __f23;
		public String Properties
		{
			get { return this.__f23; }
			set
			{
				if (this.__f23 == value) return;
				this.__f23 = value; this.__changed[23] = true;
			}
		}
		Boolean __f24;
		public Boolean Enabled
		{
			get { return this.__f24; }
			set
			{
				if (this.__f24 == value) return;
				this.__f24 = value; this.__changed[24] = true;
			}
		}
		Int32? __f25;
		public Int32? ReferenceID
		{
			get { return this.__f25; }
			set
			{
				if (this.__f25 == value) return;
				this.__f25 = value; this.__changed[25] = true;
			}
		}
		DateTime? __f26;
		public DateTime? LastUpdateOn
		{
			get { return this.__f26; }
			set
			{
				if (this.__f26 == value) return;
				this.__f26 = value; this.__changed[26] = true;
			}
		}
		String __f27;
		public String LastUpdatedBy
		{
			get { return this.__f27; }
			set
			{
				if (this.__f27 == value) return;
				this.__f27 = value; this.__changed[27] = true;
			}
		}
		DateTime? __f28;
		public DateTime? CreatedOn
		{
			get { return this.__f28; }
			set
			{
				if (this.__f28 == value) return;
				this.__f28 = value; this.__changed[28] = true;
			}
		}
		String __f29;
		public String CreatedBy
		{
			get { return this.__f29; }
			set
			{
				if (this.__f29 == value) return;
				this.__f29 = value; this.__changed[29] = true;
			}
		}
		Boolean __f30;
		public Boolean Active
		{
			get { return this.__f30; }
			set
			{
				if (this.__f30 == value) return;
				this.__f30 = value; this.__changed[30] = true;
			}
		}
		DateTime? __f31;
		public DateTime? LastDeleteOn
		{
			get { return this.__f31; }
			set
			{
				if (this.__f31 == value) return;
				this.__f31 = value; this.__changed[31] = true;
			}
		}
		String __f32;
		public String LastDeletedBy
		{
			get { return this.__f32; }
			set
			{
				if (this.__f32 == value) return;
				this.__f32 = value; this.__changed[32] = true;
			}
		}
		DateTime? __f33;
		public DateTime? LastReactivateOn
		{
			get { return this.__f33; }
			set
			{
				if (this.__f33 == value) return;
				this.__f33 = value; this.__changed[33] = true;
			}
		}
		String __f34;
		public String LastReactivatedBy
		{
			get { return this.__f34; }
			set
			{
				if (this.__f34 == value) return;
				this.__f34 = value; this.__changed[34] = true;
			}
		}
		Int32? __f35;
		public Int32? ArchiveID
		{
			get { return this.__f35; }
			set
			{
				if (this.__f35 == value) return;
				this.__f35 = value; this.__changed[35] = true;
			}
		}
		DateTime? __f36;
		public DateTime? LastArchiveOn
		{
			get { return this.__f36; }
			set
			{
				if (this.__f36 == value) return;
				this.__f36 = value; this.__changed[36] = true;
			}
		}
		String __f37;
		public String LastArchivedBy
		{
			get { return this.__f37; }
			set
			{
				if (this.__f37 == value) return;
				this.__f37 = value; this.__changed[37] = true;
			}
		}
		DateTime? __f38;
		public DateTime? LastRestoreOn
		{
			get { return this.__f38; }
			set
			{
				if (this.__f38 == value) return;
				this.__f38 = value; this.__changed[38] = true;
			}
		}
		String __f39;
		public String LastRestoredBy
		{
			get { return this.__f39; }
			set
			{
				if (this.__f39 == value) return;
				this.__f39 = value; this.__changed[39] = true;
			}
		}
		public SfViewAction()
		{
			this.__table = "SF_VIEW_ACTION";
			this.__fields = new [] { "ID","ViewRevisionID","Name","FUID","Defined","PositionOrder","Type","TitleTextID","ShowTitle","OnActionOperationCode","OnActionOperationID","NextViewAction","TargetScreenType","TargetScreenID","TargetScreenRevisionID","PopupViewID","PopupViewRevisionID","GroupTag","Keyboard","Style","CssClass","Image","AvailabilityMode","Properties","Enabled","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16,()=>this.__f17,()=>this.__f18,()=>this.__f19,()=>this.__f20,()=>this.__f21,()=>this.__f22,()=>this.__f23,()=>this.__f24,()=>this.__f25,()=>this.__f26,()=>this.__f27,()=>this.__f28,()=>this.__f29,()=>this.__f30,()=>this.__f31,()=>this.__f32,()=>this.__f33,()=>this.__f34,()=>this.__f35,()=>this.__f36,()=>this.__f37,()=>this.__f38,()=>this.__f39 };
			this.__changed = new bool[40];
			this.__isPK = new [] { true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = 0;
		}
		protected override void SetIdentity(int value)
		{
			this.__f0 = value;
		}
		public static SfViewAction LoadByPK(Sql sql, Int32 ID)
		{
			sql.Clear();
			sql.AddInput("ID", ID);
			return LoadRecord<SfViewAction>(sql, $"SELECT {SelectQuery} WHERE [ID]=@ID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ID"];
			this.__f1 = (Int32)reader["ViewRevisionID"];
			this.__f2 = (String)reader["Name"];
			this.__f3 = (String)reader["FUID"];
			this.__f4 = (Boolean)reader["Defined"];
			this.__f5 = (Int32)reader["PositionOrder"];
			this.__f6 = (Int16)reader["Type"];
			this.__f7 = ToNullable<Int32>(reader["TitleTextID"]);
			this.__f8 = (Boolean)reader["ShowTitle"];
			this.__f9 = EmptyToNull(reader["OnActionOperationCode"]);
			this.__f10 = ToNullable<Int32>(reader["OnActionOperationID"]);
			this.__f11 = EmptyToNull(reader["NextViewAction"]);
			this.__f12 = (Int16)reader["TargetScreenType"];
			this.__f13 = ToNullable<Int32>(reader["TargetScreenID"]);
			this.__f14 = ToNullable<Int32>(reader["TargetScreenRevisionID"]);
			this.__f15 = ToNullable<Int32>(reader["PopupViewID"]);
			this.__f16 = ToNullable<Int32>(reader["PopupViewRevisionID"]);
			this.__f17 = EmptyToNull(reader["GroupTag"]);
			this.__f18 = ToNullable<Int16>(reader["Keyboard"]);
			this.__f19 = EmptyToNull(reader["Style"]);
			this.__f20 = EmptyToNull(reader["CssClass"]);
			this.__f21 = EmptyToNull(reader["Image"]);
			this.__f22 = (Int16)reader["AvailabilityMode"];
			this.__f23 = EmptyToNull(reader["Properties"]);
			this.__f24 = (Boolean)reader["Enabled"];
			this.__f25 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f26 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f27 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f28 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f29 = EmptyToNull(reader["CreatedBy"]);
			this.__f30 = (Boolean)reader["Active"];
			this.__f31 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f32 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f33 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f34 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f35 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f36 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f37 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f38 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f39 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfLayoutPanel : SqlStampedObject
	{
		public const string SelectQuery = "[ID],[FUID],[Name],[LayoutID],[ParentID],[PositionOrder],[LayerType],[PanelType],[OrientationType],[DefaultViewID],[DefaultViewRevisionID],[SizeValue],[SizeType],[Style],[CssClass],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_LAYOUT_PANEL]";
		Int32 __f0;
		public Int32 ID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		String __f1;
		public String FUID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		String __f2;
		public String Name
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		Int32? __f3;
		public Int32? LayoutID
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		Int32? __f4;
		public Int32? ParentID
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		Int32 __f5;
		public Int32 PositionOrder
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		Int16 __f6;
		public Int16 LayerType
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Int16 __f7;
		public Int16 PanelType
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		Int16 __f8;
		public Int16 OrientationType
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		Int32? __f9;
		public Int32? DefaultViewID
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		Int32? __f10;
		public Int32? DefaultViewRevisionID
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		Decimal __f11;
		public Decimal SizeValue
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Int16 __f12;
		public Int16 SizeType
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		String __f13;
		public String Style
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		String __f14;
		public String CssClass
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		Int32? __f15;
		public Int32? ReferenceID
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		DateTime? __f16;
		public DateTime? LastUpdateOn
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		String __f17;
		public String LastUpdatedBy
		{
			get { return this.__f17; }
			set
			{
				if (this.__f17 == value) return;
				this.__f17 = value; this.__changed[17] = true;
			}
		}
		DateTime? __f18;
		public DateTime? CreatedOn
		{
			get { return this.__f18; }
			set
			{
				if (this.__f18 == value) return;
				this.__f18 = value; this.__changed[18] = true;
			}
		}
		String __f19;
		public String CreatedBy
		{
			get { return this.__f19; }
			set
			{
				if (this.__f19 == value) return;
				this.__f19 = value; this.__changed[19] = true;
			}
		}
		Boolean __f20;
		public Boolean Active
		{
			get { return this.__f20; }
			set
			{
				if (this.__f20 == value) return;
				this.__f20 = value; this.__changed[20] = true;
			}
		}
		DateTime? __f21;
		public DateTime? LastDeleteOn
		{
			get { return this.__f21; }
			set
			{
				if (this.__f21 == value) return;
				this.__f21 = value; this.__changed[21] = true;
			}
		}
		String __f22;
		public String LastDeletedBy
		{
			get { return this.__f22; }
			set
			{
				if (this.__f22 == value) return;
				this.__f22 = value; this.__changed[22] = true;
			}
		}
		DateTime? __f23;
		public DateTime? LastReactivateOn
		{
			get { return this.__f23; }
			set
			{
				if (this.__f23 == value) return;
				this.__f23 = value; this.__changed[23] = true;
			}
		}
		String __f24;
		public String LastReactivatedBy
		{
			get { return this.__f24; }
			set
			{
				if (this.__f24 == value) return;
				this.__f24 = value; this.__changed[24] = true;
			}
		}
		Int32? __f25;
		public Int32? ArchiveID
		{
			get { return this.__f25; }
			set
			{
				if (this.__f25 == value) return;
				this.__f25 = value; this.__changed[25] = true;
			}
		}
		DateTime? __f26;
		public DateTime? LastArchiveOn
		{
			get { return this.__f26; }
			set
			{
				if (this.__f26 == value) return;
				this.__f26 = value; this.__changed[26] = true;
			}
		}
		String __f27;
		public String LastArchivedBy
		{
			get { return this.__f27; }
			set
			{
				if (this.__f27 == value) return;
				this.__f27 = value; this.__changed[27] = true;
			}
		}
		DateTime? __f28;
		public DateTime? LastRestoreOn
		{
			get { return this.__f28; }
			set
			{
				if (this.__f28 == value) return;
				this.__f28 = value; this.__changed[28] = true;
			}
		}
		String __f29;
		public String LastRestoredBy
		{
			get { return this.__f29; }
			set
			{
				if (this.__f29 == value) return;
				this.__f29 = value; this.__changed[29] = true;
			}
		}
		public SfLayoutPanel()
		{
			this.__table = "SF_LAYOUT_PANEL";
			this.__fields = new [] { "ID","FUID","Name","LayoutID","ParentID","PositionOrder","LayerType","PanelType","OrientationType","DefaultViewID","DefaultViewRevisionID","SizeValue","SizeType","Style","CssClass","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16,()=>this.__f17,()=>this.__f18,()=>this.__f19,()=>this.__f20,()=>this.__f21,()=>this.__f22,()=>this.__f23,()=>this.__f24,()=>this.__f25,()=>this.__f26,()=>this.__f27,()=>this.__f28,()=>this.__f29 };
			this.__changed = new bool[30];
			this.__isPK = new [] { true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = 0;
		}
		protected override void SetIdentity(int value)
		{
			this.__f0 = value;
		}
		public static SfLayoutPanel LoadByPK(Sql sql, Int32 ID)
		{
			sql.Clear();
			sql.AddInput("ID", ID);
			return LoadRecord<SfLayoutPanel>(sql, $"SELECT {SelectQuery} WHERE [ID]=@ID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ID"];
			this.__f1 = (String)reader["FUID"];
			this.__f2 = (String)reader["Name"];
			this.__f3 = ToNullable<Int32>(reader["LayoutID"]);
			this.__f4 = ToNullable<Int32>(reader["ParentID"]);
			this.__f5 = (Int32)reader["PositionOrder"];
			this.__f6 = (Int16)reader["LayerType"];
			this.__f7 = (Int16)reader["PanelType"];
			this.__f8 = (Int16)reader["OrientationType"];
			this.__f9 = ToNullable<Int32>(reader["DefaultViewID"]);
			this.__f10 = ToNullable<Int32>(reader["DefaultViewRevisionID"]);
			this.__f11 = (Decimal)reader["SizeValue"];
			this.__f12 = (Int16)reader["SizeType"];
			this.__f13 = EmptyToNull(reader["Style"]);
			this.__f14 = EmptyToNull(reader["CssClass"]);
			this.__f15 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f16 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f17 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f18 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f19 = EmptyToNull(reader["CreatedBy"]);
			this.__f20 = (Boolean)reader["Active"];
			this.__f21 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f22 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f23 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f24 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f25 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f26 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f27 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f28 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f29 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfScreenPanelActionTrigger : SqlStampedObject
	{
		public const string SelectQuery = "[ScreenPanelActionID],[ScreenPanelID],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_SCREEN_PANEL_ACTION_TRIGGER]";
		Int32 __f0;
		public Int32 ScreenPanelActionID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32 __f1;
		public Int32 ScreenPanelID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32? __f2;
		public Int32? ReferenceID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		DateTime? __f3;
		public DateTime? LastUpdateOn
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		String __f4;
		public String LastUpdatedBy
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		DateTime? __f5;
		public DateTime? CreatedOn
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		String __f6;
		public String CreatedBy
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Boolean __f7;
		public Boolean Active
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		DateTime? __f8;
		public DateTime? LastDeleteOn
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String LastDeletedBy
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		DateTime? __f10;
		public DateTime? LastReactivateOn
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String LastReactivatedBy
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Int32? __f12;
		public Int32? ArchiveID
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		DateTime? __f13;
		public DateTime? LastArchiveOn
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		String __f14;
		public String LastArchivedBy
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		DateTime? __f15;
		public DateTime? LastRestoreOn
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		String __f16;
		public String LastRestoredBy
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		public SfScreenPanelActionTrigger()
		{
			this.__table = "SF_SCREEN_PANEL_ACTION_TRIGGER";
			this.__fields = new [] { "ScreenPanelActionID","ScreenPanelID","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16 };
			this.__changed = new bool[17];
			this.__isPK = new [] { true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = -1;
		}
		public static SfScreenPanelActionTrigger LoadByPK(Sql sql, Int32 ScreenPanelActionID,Int32 ScreenPanelID)
		{
			sql.Clear();
			sql.AddInput("ScreenPanelActionID", ScreenPanelActionID);
			sql.AddInput("ScreenPanelID", ScreenPanelID);
			return LoadRecord<SfScreenPanelActionTrigger>(sql, $"SELECT {SelectQuery} WHERE [ScreenPanelActionID]=@ScreenPanelActionID AND [ScreenPanelID]=@ScreenPanelID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ScreenPanelActionID"];
			this.__f1 = (Int32)reader["ScreenPanelID"];
			this.__f2 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f3 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f4 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f5 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f6 = EmptyToNull(reader["CreatedBy"]);
			this.__f7 = (Boolean)reader["Active"];
			this.__f8 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f9 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f10 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f11 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f12 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f13 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f14 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f15 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f16 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
	public partial class SfViewActionParameter : SqlStampedObject
	{
		public const string SelectQuery = "[ViewActionID],[ParameterID],[ReferenceID],[LastUpdateOn],[LastUpdatedBy],[CreatedOn],[CreatedBy],[Active],[LastDeleteOn],[LastDeletedBy],[LastReactivateOn],[LastReactivatedBy],[ArchiveID],[LastArchiveOn],[LastArchivedBy],[LastRestoreOn],[LastRestoredBy],[RowVersionStamp] FROM [SF_VIEW_ACTION_PARAMETER]";
		Int32 __f0;
		public Int32 ViewActionID
		{
			get { return this.__f0; }
			set
			{
				if (this.__f0 == value) return;
				this.__f0 = value; this.__changed[0] = true;
			}
		}
		Int32 __f1;
		public Int32 ParameterID
		{
			get { return this.__f1; }
			set
			{
				if (this.__f1 == value) return;
				this.__f1 = value; this.__changed[1] = true;
			}
		}
		Int32? __f2;
		public Int32? ReferenceID
		{
			get { return this.__f2; }
			set
			{
				if (this.__f2 == value) return;
				this.__f2 = value; this.__changed[2] = true;
			}
		}
		DateTime? __f3;
		public DateTime? LastUpdateOn
		{
			get { return this.__f3; }
			set
			{
				if (this.__f3 == value) return;
				this.__f3 = value; this.__changed[3] = true;
			}
		}
		String __f4;
		public String LastUpdatedBy
		{
			get { return this.__f4; }
			set
			{
				if (this.__f4 == value) return;
				this.__f4 = value; this.__changed[4] = true;
			}
		}
		DateTime? __f5;
		public DateTime? CreatedOn
		{
			get { return this.__f5; }
			set
			{
				if (this.__f5 == value) return;
				this.__f5 = value; this.__changed[5] = true;
			}
		}
		String __f6;
		public String CreatedBy
		{
			get { return this.__f6; }
			set
			{
				if (this.__f6 == value) return;
				this.__f6 = value; this.__changed[6] = true;
			}
		}
		Boolean __f7;
		public Boolean Active
		{
			get { return this.__f7; }
			set
			{
				if (this.__f7 == value) return;
				this.__f7 = value; this.__changed[7] = true;
			}
		}
		DateTime? __f8;
		public DateTime? LastDeleteOn
		{
			get { return this.__f8; }
			set
			{
				if (this.__f8 == value) return;
				this.__f8 = value; this.__changed[8] = true;
			}
		}
		String __f9;
		public String LastDeletedBy
		{
			get { return this.__f9; }
			set
			{
				if (this.__f9 == value) return;
				this.__f9 = value; this.__changed[9] = true;
			}
		}
		DateTime? __f10;
		public DateTime? LastReactivateOn
		{
			get { return this.__f10; }
			set
			{
				if (this.__f10 == value) return;
				this.__f10 = value; this.__changed[10] = true;
			}
		}
		String __f11;
		public String LastReactivatedBy
		{
			get { return this.__f11; }
			set
			{
				if (this.__f11 == value) return;
				this.__f11 = value; this.__changed[11] = true;
			}
		}
		Int32? __f12;
		public Int32? ArchiveID
		{
			get { return this.__f12; }
			set
			{
				if (this.__f12 == value) return;
				this.__f12 = value; this.__changed[12] = true;
			}
		}
		DateTime? __f13;
		public DateTime? LastArchiveOn
		{
			get { return this.__f13; }
			set
			{
				if (this.__f13 == value) return;
				this.__f13 = value; this.__changed[13] = true;
			}
		}
		String __f14;
		public String LastArchivedBy
		{
			get { return this.__f14; }
			set
			{
				if (this.__f14 == value) return;
				this.__f14 = value; this.__changed[14] = true;
			}
		}
		DateTime? __f15;
		public DateTime? LastRestoreOn
		{
			get { return this.__f15; }
			set
			{
				if (this.__f15 == value) return;
				this.__f15 = value; this.__changed[15] = true;
			}
		}
		String __f16;
		public String LastRestoredBy
		{
			get { return this.__f16; }
			set
			{
				if (this.__f16 == value) return;
				this.__f16 = value; this.__changed[16] = true;
			}
		}
		public SfViewActionParameter()
		{
			this.__table = "SF_VIEW_ACTION_PARAMETER";
			this.__fields = new [] { "ViewActionID","ParameterID","ReferenceID","LastUpdateOn","LastUpdatedBy","CreatedOn","CreatedBy","Active","LastDeleteOn","LastDeletedBy","LastReactivateOn","LastReactivatedBy","ArchiveID","LastArchiveOn","LastArchivedBy","LastRestoreOn","LastRestoredBy" };
			this.__map = new Func<object>[] { ()=>this.__f0,()=>this.__f1,()=>this.__f2,()=>this.__f3,()=>this.__f4,()=>this.__f5,()=>this.__f6,()=>this.__f7,()=>this.__f8,()=>this.__f9,()=>this.__f10,()=>this.__f11,()=>this.__f12,()=>this.__f13,()=>this.__f14,()=>this.__f15,()=>this.__f16 };
			this.__changed = new bool[17];
			this.__isPK = new [] { true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false };
			this.__identity = -1;
		}
		public static SfViewActionParameter LoadByPK(Sql sql, Int32 ViewActionID,Int32 ParameterID)
		{
			sql.Clear();
			sql.AddInput("ViewActionID", ViewActionID);
			sql.AddInput("ParameterID", ParameterID);
			return LoadRecord<SfViewActionParameter>(sql, $"SELECT {SelectQuery} WHERE [ViewActionID]=@ViewActionID AND [ParameterID]=@ParameterID");
		}
		protected override void LoadData(DbDataReader reader)
		{
			this.__f0 = (Int32)reader["ViewActionID"];
			this.__f1 = (Int32)reader["ParameterID"];
			this.__f2 = ToNullable<Int32>(reader["ReferenceID"]);
			this.__f3 = ToNullable<DateTime>(reader["LastUpdateOn"]);
			this.__f4 = EmptyToNull(reader["LastUpdatedBy"]);
			this.__f5 = ToNullable<DateTime>(reader["CreatedOn"]);
			this.__f6 = EmptyToNull(reader["CreatedBy"]);
			this.__f7 = (Boolean)reader["Active"];
			this.__f8 = ToNullable<DateTime>(reader["LastDeleteOn"]);
			this.__f9 = EmptyToNull(reader["LastDeletedBy"]);
			this.__f10 = ToNullable<DateTime>(reader["LastReactivateOn"]);
			this.__f11 = EmptyToNull(reader["LastReactivatedBy"]);
			this.__f12 = ToNullable<Int32>(reader["ArchiveID"]);
			this.__f13 = ToNullable<DateTime>(reader["LastArchiveOn"]);
			this.__f14 = EmptyToNull(reader["LastArchivedBy"]);
			this.__f15 = ToNullable<DateTime>(reader["LastRestoreOn"]);
			this.__f16 = EmptyToNull(reader["LastRestoredBy"]);
		}
		protected override string __StampCode { get { return "RowVersionStamp"; } }
	}
}
